首页 > 代码库 > JdbcUtil类的编写
JdbcUtil类的编写
package dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
public class JdbcUtil {
public static final String url = "jdbc:mysql://localhost:3306/mydatabase";
public static final String name = "com.mysql.jdbc.Driver";
public static final String user = "root";
public static final String password = "12344";
public Connection conn = null;
public PreparedStatement pst = null;
public JdbcUtil(String sql) {
try {
Class.forName(name);//注册驱动
conn = DriverManager.getConnection(url, user, password);//获取连接
pst = conn.prepareStatement(sql);//准备执行语句
} catch (Exception e) {
e.printStackTrace();
}
}
public void close() {
try {
this.conn.close();
this.pst.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
JdbcUtil类的编写