?? updateuser2.jsp
字號:
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<script language="javascript">
function on_submit()
{//驗證數據的合法性
if (form1.username.value == "")
{
alert("用戶名不能為空，請輸入用戶名！");
form1.username.focus();
return false;
}
}
</script>
<%//接收要修改的用戶ID號
long user_id;
try
{
user_id=Long.parseLong(request.getParameter("user_id"));
}
catch(Exception e)
{
user_id=0;
}
%>
<head>
<title>修改用戶資料程序</title>
</head>
<body>
<center>
<%if(user_id!=0)
{
String sqlString="select * from userTable where user_id="+user_id;
try
{ Connection con;
Statement sql;
ResultSet rs;
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=testDatabse","sa","");
sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=sql.executeQuery(sqlString);
rs.next();
%>
<table border="1" width="700">
<tr>
<td width="100%" colspan="2" align="center">修改用戶資料程序</td>
</tr>
<form action="updateUser3.jsp" method="post" onsubmit="return on_submit()" name="form1">
<input type="hidden" value="<%=user_id%>" name="user_id">
<tr>
<td width="25%">用戶名:</td>
<td width="75%"><input type="text" name="username" value="<%=rs.getString("user_name")%>"></td>
</tr>
<tr>
<td >真實姓名:</td>
<td ><input type="text" name="usertruename" value="<%=rs.getString("user_true_name")%>"></td>
</tr>
<tr>
<td >年齡:</td>
<td ><input type="text" name="age" value="<%=rs.getString("user_age")%>"></td>
</tr>
<tr>
<td>性別:</td>
<td >
<%if((rs.getString("user_sex")).equals("男"))
{%>
<input type="radio" name="sex" value="男" checked>
<%
}
else
{
%>
<input type="radio" name="sex" value="男">
<%
}
%>
男
<%if((rs.getString("user_sex")).equals("女"))
{%>
<input type="radio" value="女" name="sex" checked>
<%
}
else
{
%>
<input type="radio" name="sex" value="女">
<%
}
%>
女
</td>
</tr>
<tr>
<td>聯系地址:</td>
<td ><input type="text" name="address" size="60" value="<%=rs.getString("user_address")%>"></td>
</tr>
<tr>
<td>聯系電話:</td>
<td ><input type="text" name="telephoe" value="<%=rs.getString("user_telephone")%>"></td>
</tr>
<tr>
<td colspan="2" align="center"> <input type="submit" value="提交"><input type="reset" value="重輸"></td>
</tr>
</form>
</table>
<%
con.close();
}
catch(SQLException e1)
{
out.print("SQL異常！");
}
}
else
{
out.print("數據不正確!");
}%>
</center>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -