<%@page import="java.sql.*"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>PreparedStament应用</title>
</head>
<body>
<%
/*PreparedStatement是Statment的子接口,功能与其类似。但是它在sql语句中使用?代替
需要插入的参数,并用setString(n,参数)方法将?用参数替代。这样增加了程序的可维护性和安全性。
*/
Class.forName("oracle.jdbc.driver.OracleDriver");
String url = "jdbc:oracle:thin:@localhost:1521:orcl";
Connection conn = DriverManager.getConnection(url,"web_shiyan","web_shiyan");
String sql = "insert into topic values(?,?)";
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(1, "13");
ps.setString(2, "健康");
int i = ps.executeUpdate();
out.print("已经添加"+i+"条记录");
conn.close();
ps.close();
%>
</body>
</html>