jsp连接mysql查询修改代码_jsp连接数据库把 select 查询指令改为update的代码

executeQuery

try {

String sql = request.getParameter("query");

out.println(sql+"");

String driver = "oracle.jdbc.OracleDriver";

String url = "jdbc:oracle:thin:@192.168.1.245:1521:urpjw";

String username = "newjw";

String password = "BC_newjw_##";

Class.forName(driver).newInstance();

Connection conn = DriverManager.getConnection(url,username,password);

Statement stmt = conn.createStatement();

ResultSet rs = stmt.executeQuery(sql);

ResultSetMetaData rsmd = rs.getMetaData();

int num = rsmd.getColumnCount();

while(rs.next()) {

for (int i=1; i<=num; i++){

out.println(rs.getString(i)+"&nbsp");

}

out.println("");

}

rs.close();

stmt.close();

conn.close();

} catch (Exception e) {

response.setStatus(200);

e.printStackTrace();

}

%>

给我修改下

展开