📄 type_1.jsp
字号:
<%@ page language="java" import="java.util.*" pageEncoding="GBK"%>
<%@ page import="DataBase.DBConn"%>
<%@ page import="java.sql.ResultSet"%>
<script Language="vbscript">
sub check()
c=document.form1.page.value
if c<>"" then
if not IsNumeric(c) then
msgbox " 页数只能输入数字"
document.form1.page.select()
exit sub
else
end if
else
msgbox"请输入想要转到页数"
document.form1.page.select()
exit sub
end if
document.form1.submit()
end sub
</script>
<html>
<head>
<%!String keywords ;
String topage;
// 设置每张网业显示30笔记录
int pagesize=30;
//设置预显示的页数
int showpage=1;
// ResultSet记录的笔数
int rowcount =0;
// 分页后的总页数
int pagecount=0;
int id;
String str1;
String str2;
String bg;
String daan;
String sql;
%>
<title>网上考试系统</title>
<link rel="stylesheet" type="text/css" href="css.css">
</head>
<body topmargin="0" leftmargin="0">
<%
request.setCharacterEncoding("GBK");
response.setCharacterEncoding("GBK");
topage=request.getParameter("page");
String keyword=request.getParameter("keyword");
if( keyword==null ){
keywords="所有题目";
}
else{
keywords=keyword;
}
%>
<p>
<p align="center"><font class=test1>判断题 题库管理</font><br>
<a href="type_1_add.jsp">添加新题</a></p>
<div align="center">
<center>
<table border="1" cellpadding="5" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="600">
<form method="post" name=form2 action="type_1.jsp">
<tr>
<td align="center" colspan="5">以下是按关键字<font color=red> <%=keywords%> </font>的查询结果
查找 <input type="text" name="keyword" size="20" > 题目<input type="submit" value="查找" name="B1"></td>
</tr>
</form>
<tr>
<td width="50" align="center" bgcolor="#CBEFDC">编号</td>
<td width="400" align="center" bgcolor="#CBEFDC">题目</td>
<td width="50" align="center" bgcolor="#CBEFDC">答案</td>
<td width="50" align="center" bgcolor="#CBEFDC">编辑</td>
<td width="50" align="center" bgcolor="#CBEFDC">删除</td>
</tr>
<% if(keywords.equals("所有题目")){
sql="select * from pdt";
}else{
sql="select * from pdt where tgan like '%"+keyword+"%' order by id desc";
}
DBConn db=new DBConn();
ResultSet rs=db.Query(sql);
rs.last();
rowcount=rs.getRow();
pagecount=((rowcount%pagesize)==0?
(rowcount/pagesize):(rowcount/pagesize+1));
%>
<%if(topage!=null){
showpage=Integer.parseInt(topage);
if(showpage>pagecount)
{
showpage=pagecount;
}
else if(showpage<=0)
{
showpage=1;
}
}
rs.absolute((showpage-1)*pagesize+1); %>
<%for(int i=1;i<=pagesize;){%>
<% if(rowcount==0){%>
<tr><td colspan=5><center><font color=red>没有你查的试题信息</font></center></td></tr>
<%break;}%>
<% i++;
daan=rs.getString("dan");
id=rs.getInt("id");
if(i%2==0)
{
bg="#E9F8F0";
}else{
bg="#ffffff";
}
if(daan.equals("0")){
daan="错误";
}
else{
daan="正确";
}%>
<tr bgcolor=<%=bg%>>
<td align="center"><%=id%></td>
<td><%=rs.getString("tgan")%></td>
<td align="center"><%=daan%></td>
<td align="center"><a href="type_1_edit.jsp?id=<%=id%>">编辑</a></td>
<td align="center"><a href="type_1_del.jsp?id=<%=id%>">删除</a></td>
</tr>
<%if(!rs.next()){
break;}%>
<%}%>
<tr>
<td colspan="5" align="center">
<p align="center">
<form action=type_1.jsp method="post" name=form1 >
30条一页 <a href="type_1.jsp?page=1" target="right">第一页</a> ⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -