📄 problems.jsp
字号:
<%@ page language="java" import="java.util.*" pageEncoding="GB2312"%>
<%@ page import="java.sql.*" %>
<%@ include file="connDB.jsp"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body onContentMenu="return false">
<%
Random r=new Random();//随机数
int ran=r.nextInt(7);
%>
<table width="400" border="1" align="center" bordercolor="#FFFF00">
<tr>
<td width="155" rowspan="4">
<%
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
int randomNumber1=ran+3;
conn= DriverManager.getConnection(url);
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
sql="select * from people where id='"+randomNumber1+"'";
rs=stmt.executeQuery(sql);
%><% while(rs.next()) {%>
<table width="147" border="1" bordercolor="#33CC33">
<tr>
<td width="120" height="131"><img src="images/<%=rs.getString(3)%>"></td>
</tr>
<tr>
<td><strong>简介</strong></td>
</tr>
<tr>
<td><strong>姓名：</strong><em><%=rs.getString(2)%></em></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td> </td>
</tr>
</table>
<%}%>
<%rs.close();
stmt.close();
conn.close();
%> </td>
<td width="260" rowspan="4">
<form name="form1" method="post" action="">
<%Class.forName("org.gjt.mm.mysql.Driver").newInstance();
int randomNumber2=ran+3;
conn= DriverManager.getConnection(url);
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
sql="select * from problems where no='"+randomNumber2+"'";
rs=stmt.executeQuery(sql);
rs.last();
int n=rs.getRow();
%>
<table width="226" border="1" bordercolor="#FF0033">
<%
rs.absolute(1);
for(int i=1;i<=n;i++,rs.next()) {%>
<tr>
<td colspan="5"><%=i%>:<%=rs.getString(2)%></td>
</tr>
<tr>
<td width="23" nowrap><input type="radio" name="radio"> </td>
<td colspan="2"><input type="radio" name="radio"><%=rs.getString(3)%></td>
<td width="50"><input type="radio" name="radio"></td>
<td width="35"><input type="radio" name="radio"></td>
</tr>
<%}%>
<tr>
<td width="48" height="69"><div align="right"></div></td>
<td colspan="2"><input type="submit" name="submit" value="提交"></td>
<td width="50"><input type="reset" name="reset" value="取消"></td>
<td colspan="3"><div align="left"></div></td>
</table>
<%rs.close();
stmt.close();
conn.close();
%>
</form></td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -