To solve the problem of generating SQL Server object error using the gernerator tool in jfinal 3.0 +

1. Make sure that the database connection information configuration file format is correct SQL Server correct format (pro test) jdbcUrl =jdbc:sqlserver://localhost:1433;DatabaseName=WineERP driverClass =com.microsoft.sqlserver.jdbc.SQLServerDriver user =sa password =1   2. Make sure to add the correct SQL Server connection driver to the ...

Posted on Thu, 02 Apr 2020 07:09:32 -0400 by james13009

PyQt5 - 04 logic is separated from the interface and sqlite3+hashlib is used to implement the login interface

Use pyqt5+sqlite3+hashlib module to realize the encrypted login interface with database, and separate the logic and interface. Database generation Generate a sqlite database. The reason for using sqlite here is that it is simple and does not need to be deployed. You can replace the database and corresponding modules accordin ...

Posted on Thu, 02 Apr 2020 03:57:49 -0400 by Spud_Nic

2, SpringBoot -- configuration file description

1, Purpose of profile In project development, we often use configuration files to write some public information to the configuration, such as database configuration information, port configuration information, etc. Creating a spring boot project through IDEA will automatically generate a configuration file of application.properties. The conte ...

Posted on Thu, 02 Apr 2020 03:09:33 -0400 by Zero20two

Profile Yaml

Yaml I. Introduction (1) YAML language (pronunciation / ˈ j æ m ə l /) is designed to facilitate human reading and writing. It is essentially a general data serialization format. (2) Basic rules Case sensitive Use indents to represent hierarchy Tab is not allowed when indenting, only spaces are allowed. ...

Posted on Thu, 02 Apr 2020 02:46:40 -0400 by frog_

Troubleshooting method of Chinese query garbled code in MySQL

For the MySQL database just installed, create the database create msgBoard and create the table before changing any configuration and character set: create table msg ( id int, title varchar(60), name varchar(10), content varchar(1000) ); Then insert the data into the table: insert into msg (id, title, nam ...

Posted on Thu, 02 Apr 2020 01:40:21 -0400 by rpieszak

samba installation of file sharing software

Installation environment centos7.3 Firewall OFF selinux off 1, installation rpm -qa|grep samba yum list samba yum install samba 2. Modify the configuration file / etc/samba/smb.conf and set the shared directory cp /etc/samba/smb.conf /etc/samba/smb.conf.bak vim /etc/samba/smb.conf #Add the following at the end of t ...

Posted on Thu, 02 Apr 2020 00:46:24 -0400 by whiterecluse

Simple use of MySQL stored procedure

First create a students table The SQL script is as follows: create table students( id int primary key auto_increment, age int, name varchar(20), city varchar(20) ) character set utf8; insert into students values(null, 22, 'lisa', 'Hangzhou'); insert into students values(null, 16, 'rock', 'Shanghai'); insert into students values ...

Posted on Wed, 01 Apr 2020 22:17:06 -0400 by Andre_Ng

Play MYSQL database basic skills

I sorted out some sql statements for beginners, and customized the basic skills necessary for playing mysql database. It is very suitable for beginners to learn! Student list create table student_info ( id int unsigned auto_increment primary key, studentname varchar(10), gender enum('male','female') ); insert in ...

Posted on Wed, 01 Apr 2020 22:06:18 -0400 by billabong0202

When MYSQL designs a table, it needs two TIMESTAMP fields

Sometimes, the database table has such a requirement, which requires a record creation time and a record modification time.  The ideal design is that the initial value of the update time is the same as the creation time: CREATE TABLE `test_table` (   `id` INT( 10 ) NOT NULL,   `create_time` TIMESTAMP NOT NULL DEF ...

Posted on Wed, 01 Apr 2020 21:40:41 -0400 by vboyz

[ShardingSphere] 1. Mysql database master-slave setup

mysql 5.7 installation This is a series of articles ShardingSphere The first article in this article is about how to build a master for Mysql.The setup environment is centos 7.7 and the database version is 5.7.Three virtual machines are needed, one master and two slaves. Readers can create virtual machines on their own computers, or they can b ...

Posted on Wed, 01 Apr 2020 15:39:19 -0400 by surfnjunkie