【JSP开源代码栏目提醒】:网学会员JSP开源代码为您提供update-stu.jsp参考,解决您在update-stu.jsp学习中工作中的难题,参考学习。
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<HTML>
<HEAD>
<TITLE>使用JDBC-ODBC桥连接ACCESS数据库</TITLE>
</HEAD>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //载入驱动
程序类别
String url = "jdbc:odbc:studentdata";
String user = "";
String pwd = "";
Connection con = DriverManager.getConnection(url, user, pwd); //建立数据库链接,studentdata为ODBC数据源名称
//建立Statement对象
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
String id=request.getParameter("id");
if(id==null)
id="";
String
sql ="select name,sex,age,weight from stu_info where id ='" + id + "'";
ResultSet rs = stmt.executeQuery(sql); //建立ResultSet(结果集)对象,并执行SQL语句
while(rs.next())
{
String name = rs.getString("name");
String sex = rs.getString("sex");
int age = rs.getInt("age");
int weight = rs.getInt("weight");
request.setAttribute("id",id);
%>
<BODY>
<CENTER>
<FONT SIZE = 5 COLOR = blue>学生信息
管理系统</FONT>
<form action="update-stu2.jsp">
<table border="1"><input type="hidden" name="id" value=<%=id %>>
<tr><td>用户名:</td><td><input type="text" name="name" value=<%=name %>></td></tr>
<tr><td>性别:</td><td>
<%if(sex.equals("女"))
{ %>
<input type="radio" name="sex" value="男">男
<input type="radio" name="sex" checked="checked" value="女">女
<%
}
else
{
%>
<input type="radio" name="sex" checked="checked" value="男">男
<input type="radio" name="sex" value="女">女
<%} %>
</td></tr>
<tr><td>年龄:</td><td><input type="text" name="age" value=<%=age %>></td></tr>
<tr><td>体重:</td><td><input type="text" name="weight" value=<%=weight %>></td></tr>
<tr><td><input type="submit" value="修改"></td><td><input type="reset" value="重置"></td></tr>
</table>
</form>
</center>
</BODY>
<%
}
%>
</
HTML>