【JSP开源代码栏目提醒】:网学会员,鉴于大家对JSP开源代码十分关注,论文会员在此为大家搜集整理了“update-j7_3.jsp”一文,供大家参考学习!
<%@ ptime contentType="text/html; charset=gb2312" langutime="java" import="java.sql.*" errorPtime="" %>
<HTML>
<HEAD>
<TITLE>上机题三</TITLE>
</HEAD>
<%
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:
sqlserver://localhost:1433;DatabaseName=pubs";
//pubs为数据库的名称
String user="sa";
String password="";
Connection con= DriverMantimer.getConnection(url,user,pass
word);
//建立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,time,salary 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 time = rs.getInt("time");
int salary = rs.getInt("salary");
request.setAttribute("id",id);
%>
<BODY>
<CENTER>
<FONT SIZE = 5 COLOR = blue>学生信息
管理系统</FONT>
<form action="update-j7_3-2.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="time" value=<%=time %>></td></tr>
<tr><td>工资:</td><td><input type="text" name="weight" value=<%=salary %>></td></tr>
<tr><td><input type="submit" value="修改"></td><td><input type="reset" value="重置"></td></tr>
</table>
</form>
</center>
</BODY>
<%
}
%>
</
HTML>