}
}
//增删改
public boolean update(String sql){
Statement st;
try {
st = conn.createStatement();
int n=0;
n=st.executeUpdate(sql);
if(n>0)
return true;
} catch (SQLException e) {
e.printStackTrace();
}
return false;
}
//查询
public ResultSet query(String sql){
Statement st=null;
ResultSet rs=null;
try {
st = conn.createStatement();
rs=st.executeQuery(sql);
} catch (SQLException e) {
e.printStackTrace();
}
return rs;
}
//关闭数据库
public void close(){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
//负责完成数据库的连接及操作
public class Database {
//建立连接
private final String DRIVER_STR="com.mysql.jdbc.Driver";
//加载驱动
private final String CONN_STR="jdbc:mysql://127.0.0.1:3306/zjw useUnicode=true&characterEncoding=utf-8";
private final String USER="root";
private final String PASSWORD="123456";
private Connection conn=null;
try {
Class.forName(DRIVER_STR);
conn=DriverManager.getConnection(CONN_STR, USER, PASSWORD);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
//增删改
public boolean update(String sql){
Statement st;
try {
st = conn.createStatement();
int n=0;
n=st.executeUpdate(sql);
if(n>0)
return true;
} catch (SQLException e) {
e.printStackTrace();
}
return false;
}
//查询
public ResultSet query(String sql){
Statement st=null;
ResultSet rs=null;
try {
st = conn.createStatement();
rs=st.executeQuery(sql);
} catch (SQLException e) {
e.printStackTrace();
}
return rs;
}
//关闭数据库
public void close(){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}