📄 tianjia.jsp
字号:
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<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();
rs=sql.executeQuery("SELECT * FROM tiku");
out.println("<table width='770' border='3' align='center'>");
out.println("<tr>");
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>题目xin:</b></td>");
out.println("<td width='100'><b>新答案:</b></td>");
out.println("<td width='100'><b>修改资料:</b></td>");
//out.println("<td width='100'><b>新答案2:</b></td>");
out.println("</tr>");
while (rs.next()) {
out.println("<tr>");
String stri = new String();
stri=rs.getString(1);
out.print("<td><a href='rukaotiview.jsp?tk_id="+stri+"'>添加</a></td>");
out.println("<td>" + stri+ "</td>");
int b;
b = rs.getString(2).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>");
int a;
a = rs.getString(4).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(5) + "</td>");
//..................................题目内容
String str = new String();
str = rs.getString(6);
stri = str;
out.println("<td>" + str + "</td>");
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>");
//stri.getChars(xg1,len,array,0);
// out.println("<td>");
// int end1;
// end1=str.indexOf('|');
//int startpoistion=0;
// char chars1[]=new char[end1-startpoistion];
// str.getChars(startpoistion,end1,chars1,0);
// out.println(chars1);
//out.println("s4");
//out.println("</td>");
//if(rs.getString(7).length()>4)
//.................................题目内容
//..................................题目答案
String str1 = new String(); //答案显示ABCDE
str1 = rs.getString(7);
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>" + "1s略" + "</td>");
//...........................................题目答案
out.println("<td>" + str+ "</td>");
//out.print("<td><a href='xiugaiview.jsp?tk_id="+rs.getLong(1)+"'>修改资料</a></td>");
out.println("</tr>");
}
con.close();
%>
</body></html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -