java web2 PreparedStament应用

来源：互联网发布：中级java程序员编辑：程序博客网时间：2024/04/29 09:43

<%@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>

0 0