📄 xiugaiview.jsp
字号:
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<%//接收要修改的用户ID号
long tk_no;
try
{
tk_no=Long.parseLong(request.getParameter("tk_no"));
}
catch(Exception e)
{
tk_no=0;
}
%>
<head>
<title>修改用户资料程序</title>
</head>
<body>
<center>
<%if(tk_no!=0)
{
String sqlString="select * from tiku where tk_no="+tk_no;
try
{ Connection con;
Statement sql;
ResultSet rs;
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=kaoshi","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="xiugai.jsp" method="post" onsubmit="return on_submit()" name="form1">
<input type="hidden" value="<%=tk_no%>" name="tk_no">
<tr>
<td width="25%">题目ID:</td>
<td width="75%"><input type="text" name="tk_id" value="<%=rs.getString("tk_id")%>"></td>
</tr>
<tr>
<td width="25%">题目类别:</td>
<td width="75%"><input type="text" name="tk_class" value="<%=rs.getString("tk_class")%>"></td>
</tr>
<tr>
<td >题目分值：</td>
<td ><input type="text" name="tk_value" value="<%=rs.getString("tk_value")%>"></td>
</tr>
<tr>
<td >题目难度:</td>
<td ><input type="text" name="tk_difficulty" value="<%=rs.getString("tk_difficulty")%>"></td>
</tr>
<tr>
<td >题目内容:</td>
<td ><input type="text" name="tk_content" value="<%=rs.getString("tk_content")%>"></td>
</tr>
<tr>
<td >题目选项:</td>
<td ><input type="text" name="tk_option" value="<%=rs.getString("tk_option")%>"></td>
</tr>
</tr>
<tr>
<td >题目答案:</td>
<td ><input type="text" name="tk_standard" value="<%=rs.getString("tk_standard")%>"></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 + -