怎么在JSP表单中添加数据库表中相关记录？附代码
日期：2014-05-17 浏览次数：21006 次
如何在JSP表单中添加数据库表中相关记录？？？附代码~
- HTML code
<%@ page language="java" import="java.util.*,java.sql.*,bao.*" pageEncoding="UTF-8"%>
<%
request.setCharacterEncoding("UTF-8");
//从上一页面获得用户提交表单
String sSchlNumber,sPassword;
sSchlNumber = request.getParameter("schlNumber");
sSchlNumber = sSchlNumber.replaceAll("'","''");
sPassword = request.getParameter("password");
sPassword = sPassword.replaceAll("'","''");
//检索该用户输入的信息是否正确
String query = "select * from student where 学号='" + sSchlNumber + " ' and 密码 = '" + sPassword + " '";
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
try{
//获得数据库连接
Class.forName("com.mysql.jdbc.Driver").newInstance();
conn = DriverManager.getConnection("jdbc:mysql://localhost/wode?user=root&password=123456");
//创建statement
stmt = conn.createStatement();
//执行查询
rs = stmt.executeQuery(query);
/* String num = rs.getString(1);
String name = rs.getString(2);
String sex = rs.getString(4);
String pwd = rs.getString(3);
String xueyuan = rs.getString(6);
String zhuanye = rs.getString(7);
String jiguan = rs.getString(8);
String note = rs.getString(9);
String room = rs.getString(5); 这样定义也不对，显示有错误 */
if(rs.next())
{
//往session里设置相关属性
session.setAttribute("学号",sSchlNumber);
// System.out.println(rs.getString(1)); 这句话也显示不出来
}
else{
response.sendRedirect("error.jsp");
}
}
catch(SQLException ex)
{
ex.printStackTrace();
response.sendRedirect("error.jsp");
return;
}finally{
//关闭数据库
stmt.close();
conn.close();
}
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>学生宿舍管理系统登录验证界面-by8421</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
</head>
<body>
<br><br><br>
<center><h2>你的基本信息如下，请检查，如有错误请及时联系管理员！</h2>
<table border ="1" cellpadding="0" cellspacing="0">
<tr>
<td>学号:</td><td><%=System.out.println(rs.getString(1))%></td>
</tr>
<tr>
<td>密码:</td><td><%="pwd"%></td>
</tr>
<tr>
<td>姓名:</td><td><%="name"%></td>
</tr>
<tr>
<td&
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
