12.07MVCdxm.zip

package util; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.PreparedStatement; public class DBUtil { private String className="com.mysql.cj.jdbc.Driver"; private String url="jdbc:mysql://127.0.0.1:3306/mxw?useSSL=false&serverTimezone=GMT"; private String user="root"; private String password="123456"; private Connection conn; private PreparedStatement ps; private ResultSet rs; //创建链接 public void getConn() { try { Class.forName(className); conn = DriverManager.getConnection(url,user,password); }catch(SQLException e) { e.printStackTrace(); }catch(ClassNotFoundException e) { e.printStackTrace(); } } //查询方法 public ResultSet getDataByAny(String sql,Object[] obj) { getConn(); try { ps =conn.prepareStatement(sql); for (int i = 0; i < obj.length; i++) { ps.setObject(i+1,obj[i]); } rs = ps.executeQuery(); }catch(SQLException e) { e.printStackTrace(); } return rs; } //增删改 public int updateByAny(String sql,Object[] obj) { getConn(); int n = 0; try { ps = conn.prepareStatement(sql); for (int i = 0; i < obj.length; i++) { ps.setObject(i+1,obj[i]); } n = ps.executeUpdate(); } catch (SQLException e) { e.printStackTrace(); } return n; } //关闭流 public void close() { try { if(rs!=null) { rs.close(); } if(ps!=null) { ps.close(); } if(conn!=null) { conn.close(); } }catch (SQLException e) { e.printStackTrace(); } } }