📄 zujuandanx.jsp
字号:
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<%!
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;
}
}
%>
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<script language=javascript>
function returnResult(){
var values;
values=document.zzz.result.value;
if(values.length==0) {
alert("请输入参数值！");
return ;
}
window.opener.getResult(values);//调用父页面的方法
window.close();
}
</script>
<form name="zzz" >
<input type="button" name="ddd" value="返回结果" onclick="returnResult();" >
<br>
参数值:<input type=text name="result" value="">
</form>
<form name=form1 action="" method=post>
<%
int dipage=1;//当前页码数默认为1
String pages=request.getParameter("dipage");
if(pages==null)
{
pages="1";
}
try
{
dipage=Integer.parseInt(pages);
}
catch(Exception e)
{
dipage=1;
}
%>
<%
int p;
for(p=1;p<=5;p++)
{
if((p-1)%5==0)
out.println("<br>");
int shu;
shu=(dipage-1)*5+p;
%>
<%
out.println("<input type=checkbox name=ktid value=\""+shu+"\">");
out.println("题号"+shu+"");
}
out.print("<input type=submit value=提交 name=submit>");
out.println("<br>");
%>
<HTML>
<title>用户数据</title>
<BODY>
<% Connection con;
Statement sql;
ResultSet rs;
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
}
catch(ClassNotFoundException e)
{
out.print("类找不到！");
}
try
{
con=DriverManager.getConnection
("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=kaoshi","sa","");
sql=con.createStatement
(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
//序号
String sqlString2 = null;
sqlString2 = new String(" declare @i int Set @i = 0 update tiku Set @i = @i + 1,tk_bh ='0' ");
Statement stmt2 = con.createStatement();
stmt2.executeUpdate(sqlString2);
//序号
//序号
String sqlString1 = null;
sqlString1 = new String(" declare @i int Set @i = 0 update tiku Set @i = @i + 1,tk_bh = @i where tk_class='1' ");
Statement stmt1 = con.createStatement();
stmt1.executeUpdate(sqlString1);
//序号
//复选框...........................
String sqlString = null;
String ktid[]=request.getParameterValues("ktid");
//后的
if (ktid != null) {
int size=ktid.length;
out.println("您选中了" + size + "项，分别为：<br>");
for (int i = 0; i < size; i++)
{
out.println(ktid[i] + "<br>");
sqlString = new String("insert into kaoti(tk_id,kt_class,kt_value,kt_difficulty,kt_content,kt_option,kt_standard,kt_bh) select tk_id,tk_class,tk_value,tk_difficulty,tk_content,tk_option,tk_standard,tk_class from tiku where tk_bh='"+ ktid[i].trim() + "' ");
Statement stmt = con.createStatement();
stmt.executeUpdate(sqlString);
// sqlString3 = new String("update kaotiji set kt_bh='1'where tk_bh='"+ ktid[i].trim() + "'");
//Statement stmt3 = con.createStatement();
// stmt3.executeUpdate(sqlString3);
}
}
//复选框...........................
rs=sql.executeQuery("SELECT * FROM tiku where tk_class='1'");
int countRecord=0;//记录条数
int countPageRecord=0;//每页记录条数
int countPage=0;//总页数
countPageRecord=5;//每页5条记录，要设置每页记录条数就更改这个变量的值
//得到记录的条数
rs.last();
countRecord=rs.getRow();
//得到总页数
if(countRecord%countPageRecord==0)
countPage=countRecord/countPageRecord;
else
countPage=countRecord/countPageRecord+1;
//把记录指针移至当前页第一条记录之前
if((dipage-1)*countPageRecord==0)
rs.beforeFirst();
else
rs.absolute((dipage-1)*countPageRecord);
out.print("<Table Border style='font-size: 10pt'>");
// out.print("<input type=submit value=提交 name=submit>");
out.print("<TR>");
out.print("<td colspan=9 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("<td width='100'><b>题目难度:</b></td>");
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("<td width='100'><b>题目序号:</b></td>");
out.print("</TR>");
int hao=0;
while(rs.next())
{
out.println("<tr>");
String stri = new String();
stri=rs.getString(2);
out.print("<td><a href='xiugaiview.jsp?tk_id="+stri+"'>选择</a></td>");
int b;
b = rs.getString(3).indexOf('1'); //显示单选题、多选题等类型
if (b == 0)
out.println("<td>" + "单选题" + "</td>");
else if (b == 1)
out.println("<td>" + "多选题" + "</td>");
else if (b == 2)
out.println("<td>" + "填空题" + "</td>");
else
out.println("<td>" + "判断题" + "</td>");
out.println("<td>" + rs.getString(4)+ "</td>");//显示分值
int a;
a = rs.getString(5).indexOf('1'); //显示难、中、易
if (a == 0)
out.println("<td>" + "易" + "</td>");
else if (a == 1)
out.println("<td>" + "中" + "</td>");
else
out.println("<td>" + "难" + "</td>");
out.println("<td>" + rs.getString(6) + "</td>");
//..................................题目内容
String str = new String();
str = rs.getString(7);
stri = str;
int len;
len = str.length();
int xg1, xg2, xg3, xg4;
xg1 = str.indexOf('|');
xg2 = str.indexOf("||");
xg3 = str.indexOf("|||");
xg4 = str.indexOf("||||");
char array[] = str.toCharArray();
String timu = "";
String timu1 = "";
String timu2 = "";
String timu3 = "";
String timu4 = "";
String timu5 = "";
for (int i = 0; i < xg1; i++) {
timu1 = timu1 + array[i];
}
for (int i = xg1 + 1; i < xg2; i++) //不输出斜杠所以xg1+1
{
timu2 = timu2 + array[i];
}
for (int i = xg2 + 2; i < xg3; i++) //不输出双斜杠所以xg1+2
{
timu3 = timu3 + array[i];
}
if (xg4 == -1) //区别五个选项和四个选项
{
for (int i = xg3 + 3; i < len; i++) //不输出三斜杠所以xg1+1
{
timu4 = timu4 + array[i];
}
}
else
{
for (int i = xg3 + 3; i < xg4; i++) //不输出三斜杠所以xg1+1
{
timu4 = timu4 + array[i];
}
}
if(xg4!=-1) //区别假如没有5个选项
{
for (int i = xg4 + 4; i < len; i++) //不输出三斜杠所以xg1+1
{
timu5 = timu5 + array[i];
}
}
timu=timu1+"<br>"+timu2+"<br>"+timu3+"<br>"+timu4+"<br>"+timu5;
if (timu!= "")
out.println("<td>" + timu+ "</td>");
else
out.println("<td>" + "null" + "</td>");
//.................................题目内容
//..................................题目答案
String str1 = new String(); //答案显示ABCDE
str1 = rs.getString(8);
int len1;
len1 = str1.length();
int aa, bb, cc, dd, ee;
aa = str1.indexOf('1');
bb = str1.indexOf('2');
cc = str1.indexOf('3');
dd = str1.indexOf('4');
ee = str1.indexOf('5');
String daan = new String();
for (int i = 0; i <= 4; i++) {
daan = "";
if (aa == 0)
daan = daan + "A";
if (bb == 1)
daan = daan + "B";
if (cc == 2)
daan = daan + "C";
if (dd == 3)
daan = daan + "D";
if (ee == 4)
daan = daan + "E";
}
//答案真假
if (len1 == 1 && aa == 0)
out.println("<td>" + "答案为:真" + "</td>");
else if (len1 == 1)
out.println("<td>" + "答案为:假" + "</td>");
else //填空题
if (len1 >= 4 && daan != "")
out.println("<td>" + "答案为:" + daan + "</td>");
else
out.println("<td>" + rs.getString(8)+ "</td>");
//...........................................题目答案
out.println("<td>"+rs.getString(9) +"</td>");
out.print("</TR>") ;
hao++;
if(hao>=countPageRecord) break; //当前页显示完，则退出循环
}
out.print("<TR><td colspan=9 align=center>");
out.print("共"+countRecord+"条记录,共"+countPage+"页，当前第"+dipage+"页，每页"+countPageRecord+"条记录，");
if(dipage==1)//当前是首页
;
else//当前不是首页
{
out.print("<a href=zujuandanx.jsp?dipage=1>首页</a>，");
out.print("<a href=zujuandanx.jsp?dipage="+(dipage-1)+">上一页</a>,");
}
if(dipage==countPage)//当前是末页
;
else//当前不是末页
{
out.print("<a href=zujuandanx.jsp?dipage="+(dipage+1)+">下一页</a>,");
out.print("<a href=zujuandanx.jsp?dipage="+countPage+">末页</a>");
}
out.print("</td></tr>");
out.print("</Table>");
con.close();
}
catch(SQLException e1)
{
out.print("SQL异常！");
}
%>
</BODY>
</HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -