2022,3,5学习日记

请登录

public int modifyData(String sql,Object obj[]) {//增删改
int result=0;
Connection conn=ConnMysql.getConn();
try {
PreparedStatement ps=conn.prepareStatement(sql);
for(int i=0;i ps.setObject(i+1, obj[i]);
}
result=ps.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

return result;
}



public static ResultSet getDataByAny(String sql,Object obj[]) {//查
Connection conn=ConnMysql.getConn();
ResultSet rs=null;
try {
PreparedStatement ps=conn.prepareStatement(sql);
for(int i=0;i ps.setObject(i+1, obj[i]);
}
rs=ps.executeQuery(sql);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

return rs;
}

public static Connection getConn() {
Connection conn=null;
try {
Class.forName("com.mysql.cj.jdbc.Driver");
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/2022.3.4","root","111111");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return conn;

}