📄 kaojuan2.jsp
字号:
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
<meta http-equiv="refresh" content="10">
-->
<%!
public String codeToString(String str)
{//处理中文字符串的函数
String s=str;
try
{
byte tempB[]=s.getBytes("ISO-8859-1");
s=new String(tempB);
return s;
}
catch(Exception e)
{
return s;
}
}
%>
<%
int dipage=1;//当前页码数默认为1
String pages=request.getParameter("dipage");
if(pages==null)
{
pages="1";
}
try
{
dipage=Integer.parseInt(pages);
}
catch(Exception e)
{
dipage=1;
}
%>
<%
String sqlString=null;//SQL语句
//String sqlString1=null;//SQL语句
String sjno1=codeToString(request.getParameter("sjno"));
if(sjno1==null||sjno1.trim().length()==0)//SQL语句不变
{
sqlString=new String("SELECT * FROM kaojuan");
//sqlString1=new String("SELECT * FROM kaotiji");
}
else
{
sqlString=new String("SELECT * FROM kaojuan where sj_no= '"+sjno1.trim()+"'");
//sqlString1=new String("SELECT * FROM kaojuan where sj_no='"+sjno1.trim()+"'");
}
%>
<HTML>
<BODY>
<% Connection con;
Statement sql;
ResultSet rs;
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
}
catch(ClassNotFoundException e)
{
out.print("类找不到！");
}
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);
out.print("<Table Border>");
out.print("<form action=kaojuan2.jsp method=post>");
out.print("<TR><td>查询条件:</td>");
out.print("<td colspan=12>");
out.print("试卷编号:<input type=text name=sjno>");
out.print("<input type=submit value=提交>");
out.print("</td></tr></form>");
out.print("<Table Border style='font-size: 10pt'>");
// out.print("<input type=submit value=提交 name=submit>");
out.print("<TR>");
out.print("<td colspan=11 align=center>用户数据</td>");
out.print("</TR>");
out.print("<TR>");
out.println("<td width='100'><b>考卷号:</b></td>");
out.println("<td width='100'><b>考卷名称:</b></td>");
out.println("<td width='100'><b>考卷难度:</b></td>");
out.println("</tr>");
int hao=0;
while (rs.next()) {
out.println("<tr>");
out.println("<td>" + rs.getString(2)+ "</td>");
out.println("<td>" + rs.getString(3)+ "</td>");
out.println("<td>" + rs.getString(4)+ "</td>");
out.println("</tr>");
//当前页显示完，则退出循环
}
con.close();
%>
</body></html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -