使用Apusic Studio监控SQL执行情况

<%@ page import="java.sql.*"%>

<%@ page import="javax.sql.*"%>

<%@ page import="javax.naming.*"%>

<%

Context ctx = null;

DataSource ds = null;

Connection conn = null;

Statement stmt = null;

ResultSet rs = null;

String jndi = "cyDataSource";

String sql_insert = "insert into test(id,name,code) values(1,'1','1')";

String sql_update = "update test set name='2'";

String sql_query = "select * from test";

try {

ctx = new InitialContext();

ds = (DataSource)ctx.lookup(jndi);

conn = ds.getConnection();

conn.setAutoCommit(false);

stmt = conn.createStatement();

stmt.executeUpdate(sql_insert);

stmt.close();

conn.setAutoCommit(true);

stmt = conn.createStatement();

stmt.executeUpdate(sql_update);

stmt = conn.createStatement();

rs = stmt.executeQuery(sql_query);

while(rs.next()) {

       System.out.println("id:" + rs.getObject(1) + " |name:" + rs.getObject(2) + " |code:" + rs.getObject(3));

       out.println("id:" + rs.getObject(1) + " |name:" + rs.getObject(2) + " |code:" + rs.getObject(3));

}

} catch (Exception e) {

e.printStackTrace();

} finally{

}

%>