java库存的实现_库存调拨 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<=colCount; i++){

String colName=metaData.getColumnName(i);

Object value=result.getObject(i);

map.put(colName,value);

}

restList.add(map);

}

}catch(SQLException e) {//TODO Auto-generated catch block

e.printStackTrace();

}returnrestList;

}

}