<%@ page language="java" import="java.sql.*" pageEncoding="UTF-8"%>
<html>
  <head><title>利用PreparedStatemet对象添加一条记录页面</title>
  </head>
  
  <body>
 <%String driverName="com.mysql.jdbc.Driver";
 String userName="root";
 String userPwd="513625";
 String dbName="students";
 String url1="jdbc:mysql://localhost:3306/"+dbName;
 String url2="?user="+userName+"&password="+userPwd;
 String url3="&useUnicode=true&characterEncoding=UTF-8";
 String url=url1+url2+url3;
 Class.forName(driverName);
 Connection conn=DriverManager.getConnection(url);
 String sql="Insert into stu_info(id,name,sex,age,weight,hight)values(?,?,?,?,?,?)";
 PreparedStatement pstmt=conn.prepareStatement(sql);
 pstmt.setInt(1,16);
 pstmt.setString(2,"张三");
 pstmt.setString(3,"男");
 pstmt.setInt(4,20);
 pstmt.setFloat(5,70);
 pstmt.setFloat(6,175);
 int n=pstmt.executeUpdate();
 if(n==1){%>数据插入成功!<br><% }
 else{%>数据插入失败！<br><%}
 if(pstmt!=null){pstmt.close();}
 if(conn!=null){conn.close();}%>
  </body>
</html>