<%@ page contentType="text/html; charset=GB2312" language="java" import="java.sql.*,java.util.*;" errorPage=""%>
<html>
<head>
<title>修改记录</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div align="center"><font color="#000000" size="5">修改记录</font> </div>
<%! String xuehao,url,sql,sex; %>
<%! Connection conn; %>
<%! ResultSet rs; %>
<%! Statement stmt; %>
<%
xuehao=request.getParameter("xuehao").trim();
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=university";
conn=DriverManager.getConnection(url,"admin","123456");//建立与数据库的连接
stmt=conn.createStatement();
sql="select * from student where Xuehao = '"+xuehao+" '";
rs=stmt.executeQuery(sql);
while(rs.next()){
%>
<form name="form1" method="post" action="change_query.jsp?xuehao=<%=xuehao%>">
<table width="35%" border="1" cellspacing="1" cellpadding="1" align="center">
<tr>
<td width="46%" align="center">学号 </td>
<td width="54%"> <%=rs.getObject(1)%></td>
</tr>
<tr>
<td width="46%" align="center">姓名 </td>
<td width="54%"> <input type="text" name="name" size="8" value=<%=rs.getObject(2)%>></td>
</tr>
<tr>
<td width="46%" align="center">性别</td>
<td width="54%">
<%
sex=rs.getString(3).trim();
if(sex.equals("男")){
%>
<select name="sex" size="1">
<option value="男" selected>男</option>
<option value="女">女</option>
</select>
<%
}
else{
%>
<select name="sex" size="1">
<option value="男" >男</option>
<option value="女"selected>女</option>
</select>
<%
}
%>
</td>
</tr>
<tr>
<td width="46%" align="center">年龄</td>
<td width="54%"> <input type="text" name="age" size="2" value=<%=rs.getObject(4)%>></td>
</tr>
<tr>
<td width="46%" align="center">记录</td>
<td width="54%"> <input type="text" name="jiguan" size="8" value=<%=rs.getObject(5)%>></td>
</tr>
<tr>
<td width="46%" align="center">院系</td>
<td width="54%"> <input type="text" name="department" size="8" value=<%=rs.getObject(6)%>></td>
</tr>
<tr align="center">
<td colspan="2" align="center">
<input type="submit" name="Submit" value="提交">
<input type="reset" name="reset" value="清空">
</td>
</tr>
</table>
</form>
<%
}
rs.close();
stmt.close();
conn.close();
}
catch(Exception e){
out.println(e);
}
%>
</body>
</html>