数据库连接代码:
package com.classify.dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import com.mysql.cj.xdevapi.PreparableStatement;
public class Basedao {
static {
//加载驱动
try {
Class.forName("com.mysql.cj.jdbc.Driver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static Connection getconn() {
//创建一个链接对象
Connection conn = null;
try {
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/你要连接的数据库名字?serverTimezone=UTC","用户名(一般是root)","登录数据库密码(一般是123456)");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return conn;
}
public static int exectuIUD(String sql,Object[] params) {
int count = 0;
Connection conn = Basedao.getconn();
//准备sql语句
PreparedStatement ps = null;
//insert into user("","","")value(?,?,?)
try {
//准备好语句
ps = conn.prepareStatement(sql);
for( int i=0;i<params.length;i++) {
ps.setObject(i+1, params[i]);
}
//执行语句
count = ps.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally {
Basedao.closeall(null, ps, conn);
}
return count;
}
public static void closeall(ResultSet rs, PreparedStatement ps, Connection conn) {
try {
if(rs!=null) {
rs.close();
}
if(ps!=null)
ps.close();
if(conn!=null)
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}