我要频繁的执行三个insert into操作,现在有点慢,请问应该如何优化?
我要频繁的执行三个insert into操作,现在有点慢,请问应该如何优化?
我写了一个专门执行SQL的方法,然后连续运行三次这个方法来连续执行insert into操作
代码如下:
//--------------------------------------------------------------
public class exeSQL{
public void getExe (String sql){
String excep = "0";
try{
ResultSet objRS = null;
Statement stmt = null;
Connection conn = null;
Context ctx = null;
ctx = new InitialContext();
if (ctx == null)
throw new Exception("Error:Context!");
javax.sql.DataSource ds = (DataSource)ctx.lookup("java:comp/env/DBP");
conn = ds.getConnection();
stmt = conn.createStatement();
stmt.executeUpdate(sql);
stmt.close();
conn.close();
ctx.close();
}catch(Exception e){
excep = e.toString();
}
}
}
//-------------------------------------------------
String strSQL1,strSQL2,strSQL3 ;
strSQL1 = "insert into......";
strSQL2 = "insert into......";
strSQL3 = "insert into......";
for(;;){
doIT.getExe(strSQL1);
doIT.getExe(strSQL2);
doIT.getExe(strSQL3);
}
请问应如何优化,才能使运行效率更高呢?