通过idea使用jdbc对数据进行增删改查的操作
DAO包
package util;
import java.sql.*;
public class BaseDao {
//连接数据库
public Connection getConnection() {
try {
Class.forName(“com.mysql.jdbc.Driver”);
String url = “jdbc:mysql://localhost:3306/test”;
String user = “root”;
String password = “19970719zhyy”;
Connection conn = DriverManager.getConnection(url, user, password);
return conn;
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return null;
}
//关闭连接
public void closeAll(ResultSet rs,Statement statement,Connection conn) {
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (statement != null) {
try {
statement.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
//增删改方法
public int update(String sql) {
Connection conn = null;
Statement statement = null;
try {
conn = getConnection();
statement = conn.createStatement();
int res =statement.executeUpdate(sql);
return res;
} catch (SQLException e) {
e.printStackTrace();
}finally {
closeAll(null, statement, conn);
}
return 0;
}
//查询
public ResultSet query(String sql) {
Connection conn = null;
Statement statement = null;
ResultSet rs = null;
try {
conn = getConnection();
statement = conn.createStatement();
rs &#