mysql创建db_0106数据库,
创建表
添加一条数据,id int自增,密码:为MD5加密
insert into tb_sys values(null,admin,MD5(123),"系统管理员");
项目目录结构
com.isoft.db包下
db.properties文件
mysql.driver=com.mysql.jdbc.Driver
mysql.dburl=jdbc:mysql://127.0.0.1:3306/db_0106?userSSL=true&useUnicode=true&characterEncoding=UTF8&serverTimezone=GMT
mysql.loginname=root
mysql.loginpass=root
DBConnection.java
package com.isoft.db;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;
public class DBConnection {
private Connection conn ;
private static DBConnection newsInstance ;
public static DBConnection getInstance() {
if(null == newsInstance) {
newsInstance = new DBConnection() ;
}
return newsInstance ;
}
private DBConnection() {
Properties pros = new Properties() ;
try {
pros.load(DBConnection.class.getResourceAsStream("db.properties"));
Class.forName(pros.getProperty("mysql.driver")) ;
this.conn = DriverManager.getConnection(
pros.getProperty("mysql.dburl") ,
pros.getProperty("mysql.loginname") ,
pros.getProperty("mysql.loginpass")
) ;
} catch (IOException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
public Connection getConn() {
return conn;
}
public void closeConn() {
if(null != this.conn) {
try {
conn.close();
conn = null ;
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
com.isoft.entity包下
Sys.ava