java库存 |
您所在的位置:网站首页 › python3ide安卓版 › java库存 |
importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.sql.Statement;importjava.util.ArrayList;importjava.util.HashMap;importjava.util.List;importjava.util.Map;importjava.sql.ResultSetMetaData;public classDBUtil {private static String url = "jdbc:jtds:sqlserver://192.168.1.182:1433/erp";private static String driverClass = "net.sourceforge.jtds.jdbc.Driver";private static String userName = "sa";private static String pwd = "admin";public static finalConnection getConn() { Connection conn= null;try{ Class.forName(driverClass); }catch(ClassNotFoundException e2) {//TODO Auto-generated catch block e2.printStackTrace(); }try{ conn=DriverManager.getConnection(url, userName, pwd); }catch(SQLException e1) {//TODO Auto-generated catch block e1.printStackTrace(); }returnconn; }public static void beginTransaction(Connection conn) throwsSQLException{if(conn == null||conn.isClosed()){throw new SQLException("数据库连接异常"); } conn.setAutoCommit(false); }public static void commit(Connection conn) throwsSQLException{if(conn == null||conn.isClosed()){throw new SQLException("数据库连接异常"); } conn.commit(); conn.setAutoCommit(true); }public static boolean update(Connection conn,String sql) throwsException{ Statement state=conn.createStatement();int bs =state.executeUpdate(sql);return bs>0; }public static List>query(Connection conn,String sql ){ List> restList = null;try{ restList= new ArrayList>(); PreparedStatement prepState=conn.prepareStatement(sql); ResultSet result=prepState.executeQuery(); ResultSetMetaData metaData=result.getMetaData();int colCount =metaData.getColumnCount();while(result.next()){ Map map = new HashMap();for(int i = 1 ; i |
今日新闻 |
推荐新闻 |
CopyRight 2018-2019 办公设备维修网 版权所有 豫ICP备15022753号-3 |