⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 sql.jsp

📁 这是一个在线考试系统
💻 JSP
字号:
🔍 
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<a href=rutikuview.jsp>进入rutikuview</a><br>
<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<=10;p++)
{
   if((p-1)%5==0)
   out.println("<br>");
     int shu;
     shu=(dipage-1)*10+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 =@i ");
	 			Statement stmt2 = con.createStatement();
	 			stmt2.executeUpdate(sqlString2);
	 	    //序号
         rs=sql.executeQuery("SELECT * FROM tiku order by tk_class desc");
         int countRecord=0;//记录条数
         int countPageRecord=0;//每页记录条数
         int countPage=0;//总页数
         countPageRecord=10;//每页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("<TR><td colspan=9 align=center>用户数据</td></tr>");   
         out.print("<TR>");
	out.println("<td width='100'><b>题目入库:</b></td>");
	out.println("<td width='100'><b>题目ID号:</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>");
		out.print("<a href='xiugaiview.jsp?tk_no="+rs.getString(1)+"'>修改</a>");
		out.print("<br>");
		out.print("<br>");
		out.print("<a href='delete1.jsp?tk_no="+rs.getString(1)+"'>删除</a>");
		out.print("</td>");
		out.println("<td>" + stri+ "</td>");
		int b;
		b = rs.getString(3).indexOf('1'); //显示单选题、多选题等类型
		if (b == 0)
			out.println("<td>" + "<font color=blue>单选题</font>" + "</td>");
		else if (b == 1)
			out.println("<td>" + "多选题" + "</td>");
		else if (b == 2)
			out.println("<td>" + "<font color=green>填空题</font>" + "</td>");
		else
		out.println("<td>" + "<font color=red>判断题</font>" + "</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=sql.jsp?dipage=1>首页</a>，");
              out.print("<a href=sql.jsp?dipage="+(dipage-1)+">上一页</a>,");
           }
           if(dipage==countPage)//当前是末页
              ;
           else//当前不是末页
           {
              out.print("<a href=sql.jsp?dipage="+(dipage+1)+">下一页</a>,");
              out.print("<a href=sql.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 + -