packagecom.aaa.util;import java.sql.*;importjava.util.ArrayList;importjava.util.HashMap;importjava.util.List;importjava.util.Map;public classDBUtil {static{try{
Class.forName("com.mysql.jdbc.Driver");
}catch(ClassNotFoundException e) {
e.printStackTrace();
}
}public staticConnection getConnetion(){try{return DriverManager.getConnection("jdbc:mysql://localhost:3306/qy66?characterEnconding=UTF-8","root","root");
}catch(SQLException e) {
e.printStackTrace();
}return null;
}public static booleanexecuteUpdate(String sql,Object... args){
Connection con=null;
PreparedStatement ps=null;try{
con=DBUtil.getConnetion();
ps=con.prepareStatement(sql);for (int i = 0; i
ps.setObject(i+1,args[i]);
}int i=ps.executeUpdate();return i>0;
}catch(SQLException e) {
e.printStackTrace();
}finally{
close(con,ps,null);
}return false;
}public static List>executeQuery(String sql, Object... args){
Connection con=null;
PreparedStatement ps=null;
ResultSet rs=null;try{
con=getConnetion();
ps=con.prepareStatement(sql);for (int i = 0; i
ps.setObject(i+1,args[i]);
}
rs=ps.executeQuery();
List>list=new ArrayList<>();int count=rs.getMetaData().getColumnCount();while(rs.next()){
Mapmap= new HashMap<>();for (int i = 0; i < count; i++) {
String name= rs.getMetaData().getColumnLabel(i + 1);
map.put(name,rs.getObject(name));
}
list.add(map);
}returnlist;
}catch(SQLException e) {
e.printStackTrace();
}finally{
close(con,ps,rs);
}return null;
}private static voidclose(Connection con, PreparedStatement ps, ResultSet rs) {if (rs!=null){try{
rs.close();
}catch(SQLException e) {
e.printStackTrace();
}
}if (ps!=null){try{
ps.close();
}catch(SQLException e) {
e.printStackTrace();
}
}if (con!=null){try{
con.close();
}catch(SQLException e) {
e.printStackTrace();
}
}
}
}