dwr.rar_dwr_dwr Li_dwr be_dwr java li_java d

package db; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; public class DbQuery { private static Connection con; public static String dbUrl = "jdbc:sqlserver://192.168.1.8:1433;DatabaseName=BPA_DB"; public static void preparedStatementInsertTest_2(){ try{ con = DriverManager.getConnection(dbUrl,"devuser","devxxx"); long start = System.currentTimeMillis(); PreparedStatement pst = null; String b = "22222115-3#T200210020"; //执行1000次语句结构相同的查询 for(int i=0;i<1000;i++){ pst = con.prepareStatement("select top 1 * from BG_BGSZJLJGB_DT where bgsbh = '" + b + "'"); // /pst.setInt(1,i); pst.executeQuery(); } System.out.println("Methord_2 Execute Ellapse:"+(System.currentTimeMillis()-start)+"ms"); pst.close(); con.close(); }catch(Exception e){ e.printStackTrace();} } public static void preparedStatementInsertTest_3(){ try{ con = DriverManager.getConnection(dbUrl,"devuser","devxxx"); long start = System.currentTimeMillis(); PreparedStatement pst = null; pst = con.prepareStatement("select top 1 * from BG_BGSZJLJGB_DT where bgsbh = ?"); String b = "22222115-3#T200210020"; for(int i=0;i<1000;i++){ pst.setString(1,b); pst.executeQuery(); } System.out.println("Methord_3 Execute Ellapse:" +(System.currentTimeMillis()-start) +"ms"); pst.close(); con.close(); } catch(Exception ex){ ex.printStackTrace();} } public static void main(String [] args){ try { Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); preparedStatementInsertTest_3(); preparedStatementInsertTest_3(); preparedStatementInsertTest_2(); preparedStatementInsertTest_2(); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } } }