怎样提高数据库的访问速度

Question

1.建立连接池
2.优化sql
3.用批量处理语句
  Connection conn = Conn.getConn("sms");
        Statement stmt=conn.createStatement();
        conn.setAutoCommit(false);
        String content1[] = content.split("\n");
        for (int i = 0; i < content1.length; i++) {
            String content2[] = content1[i].split("\t");            String name = content2[0];
            String phoneNO = content2[1];
            String classname = content2[2];
            String departmentName = content2[3].trim();
            strSQL = "Insert into STUDENT (ID,NAME,PHONENO,CLASSNAME,DEPARTMENTNAME) Values (SEQ_STUDENT.Nextval,'"
                + name + "'," + phoneNO + ",'" + classname + "','" +
                departmentName + "')";
            stmt.addBatch(strSQL);
        }
        int[] updateCount=stmt.executeBatch();
        conn.commit();
        conn.setAutoCommit(true);
        stmt.close();
        conn.close();
这是例子

Answer 1

用连接池，把java中的一些方法放到数据库中实现

Answer 2

for (int i = 0; i < content1.length; i++) {
            String content2[] = content1[i].split("\t");            String name = content2[0];
            String phoneNO = content2[1];
            String classname = content2[2];
            String departmentName = content2[3].trim();
            strSQL = "Insert into STUDENT (ID,NAME,PHONENO,CLASSNAME,DEPARTMENTNAME) Values (SEQ_STUDENT.Nextval,'"
                + name + "'," + phoneNO + ",'" + classname + "','" +
                departmentName + "')";
            stmt.addBatch(strSQL);
        }
上面的代码可以考虑与StringBuilder