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();
}
}
}
dwr.rar_dwr_dwr Li_dwr be_dwr java li_java d
版权申诉
78 浏览量
2022-09-24
01:19:45
上传
评论
收藏 3.93MB RAR 举报
dwr.rar_dwr_dwr Li_dwr be_dwr java li_java d （204个子文件） 
DwrpPlainJsMarshaller.class 19KB Test.class 16KB LocalUtil.class 15KB DwrXmlConfigurator.class 15KB DefaultDebugPageGenerator.class 14KB UrlProcessor.class 12KB ObjectConverter.class 10KB BeanConverter.class 10KB AnnotationsConfigurator.class 10KB DefaultRemoter.class 9KB ContainerUtil.class 9KB FakeHttpServletRequest.class 9KB SignatureParser.class 9KB JavascriptUtil.class 8KB DefaultConverterManager.class 8KB CollectionConverter.class 7KB DefaultScriptSession.class 7KB MapConverter.class 7KB DefaultScriptSessionManager.class 7KB SpringTransactionAjaxFilter.class 7KB DefaultAccessControl.class 6KB TypeHintContext.class 6KB DwrServlet.class 6KB SpringCreator.class 6KB SpringConfigurator.class 6KB DefaultWebContext.class 6KB DwrController.class 6KB ScriptedCreator.class 6KB DefaultContainer.class 6KB ArrayConverter.class 6KB DefaultCreatorManager.class 6KB DwrUtil.class 6KB InboundContext.class 5KB DwrSystem.class 5KB ConverterUtil.class 5KB DwrSpringServlet.class 5KB DebuggingPrintWriter.class 5KB DOMConverter.class 5KB HibernateBeanConverter.class 5KB StrutsCreator.class 5KB JDOMConverter.class 4KB DOM4JConverter.class 4KB JsfCreator.class 4KB PageFlowCreator.class 4KB FakeHttpSession.class 4KB SwallowingHttpServletResponse.class 4KB DateConverter.class 4KB XOMConverter.class 4KB JavascriptChat.class 3KB ExecutionContext.class 3KB PrimitiveConverter.class 3KB Messages.class 3KB ServletLoggingOutput.class 3KB IdGenerator.class 3KB InboundVariable.class 3KB ServletConverter.class 3KB WebContextFactory$ProxyWebContext.class 3KB CreatorConfig.class 3KB DTDEntityResolver.class 3KB Effect.class 3KB EnumConverter.class 3KB Logger.class 3KB SpringContainer.class 3KB BigNumberConverter.class 3KB DbQuery.class 3KB JavaChat.class 3KB DBTest.class 2KB DefaultWebContextBuilder.class 2KB ConstructorConverter.class 2KB OutboundContext.class 2KB FacesExtensionFilter.class 2KB AuthenticationAjaxFilter.class 2KB DirectScriptConduit.class 2KB LogErrorHandler.class 2KB Logging1AjaxFilter.class 2KB Logging2AjaxFilter.class 2KB VersionUtil.class 2KB AbstractCreator.class 2KB HelloArg.class 2KB ParseResponse.class 2KB DwrpHtmlJsMarshaller.class 2KB Call.class 2KB CommonsLoggingOutput.class 2KB DefaultAjaxFilterManager.class 2KB SpringTransactionAjaxFilter$1.class 2KB WriterOutputStream.class 2KB Generator.class 2KB ScriptScope.class 2KB CharArrayConverter.class 2KB Test$TestBeanInvocationHandler.class 2KB FakeServletConfig.class 2KB StringConverter.class 2KB JavascriptChat$1.class 2KB DwrSystem$SystemScriptConduit.class 2KB ScriptProxy.class 2KB ExtraLatencyAjaxFilter.class 2KB NewCreator.class 1KB Hello.class 1KB ConversionConstants.class 1KB InboundContext$Conversion.class 1KB共 204 条
- 1
- 2
- 3
资源评论
