testdb.java

北大青鸟在线考试系统,包括在线考试模块,教师管理模块,系统管理模块

package TestClass;

import java.io.*;
import java.sql.*;
import java.util.*;
import javax.xml.parsers.*;
import org.apache.crimson.tree.*;
import org.w3c.dom.*;

public class TestDB
{
	public static void main(String args[])
	{
/*		Document doc;
	    Element TestScore = null;
	    Element person = null; 
	    Element name = null; 
	    Element identy = null; 
	    Element pass = null; 
	    Element score = null; 
	    try{
			AttendmentDBbean a2=new AttendmentDBbean();

			ResultSet results=a2.executeQuery("SELECT * FROM AttToEx INNER JOIN Attendment ON Attendment.pNo = AttToEx.pNo Where AttToEx.ExNo='ACCPno001'");
	
	      	DocumentBuilderFactory dbf = DocumentBuilderFactory.newInstance();
	      	DocumentBuilder builder=dbf.newDocumentBuilder();
	      	doc = builder.newDocument();
	      
	      	TestScore = doc.createElement("TESTSCORE"); 
	      	while (results.next())
	      	{ 
	        	person = doc.createElement("PERSON");
	        	person.setAttribute("PERSONID",results.getString("Attendment.pNo")); 
	        	TestScore.appendChild(person);
	
		        name = doc.createElement("NAME");
		        name.appendChild(doc.createTextNode(results.getString("pName")));
		        person.appendChild(name);
		
		        identy = doc.createElement("IDENTIFICATION");
		        identy.appendChild(doc.createTextNode(results.getString("pID")));
		        person.appendChild(identy);
		
		        pass = doc.createElement("TESTPASSPORT");
		        pass.appendChild(doc.createTextNode(results.getString("permitNo")));
		        person.appendChild(pass);
	
		        score = doc.createElement("SCORE");
		        score.appendChild(doc.createTextNode(String.valueOf(results.getDouble("pScore"))));
		        person.appendChild(score);
	      }
	      doc.appendChild(TestScore);
	      ((XmlDocument)doc).write(System.out);
		  ((XmlDocument)doc).write(new java.io.FileOutputStream("ABC.xml"));
	    }
	    catch(Exception e){}
*/
		AttendmentBean a1=new AttendmentBean();
		AttendmentDBbean a2=new AttendmentDBbean();
		ExToSubBean ee1=new ExToSubBean();
		ExToSubDBbean ee2=new ExToSubDBbean();
		SubjectBean s1=new SubjectBean();
		SubjectDBbean s2=new SubjectDBbean();

		AttendmentBean abean=null;
		AttendmentDBbean adbBean=null;

		ExamBean e1=new ExamBean();
		ExamDBbean e2=new ExamDBbean();

		AttToExBean scoreBean=new AttToExBean();
		AttToExDBbean scoredbBean=new AttToExDBbean();

		ManagerBean bean=new ManagerBean();
		//实例数据操作组件
		ManagerDBbean dbBean=new ManagerDBbean();
		try
		{
			ResultSet Rs=a2.executeQuery("SELECT * FROM AttToEx INNER JOIN Attendment ON Attendment.pNo = AttToEx.pNo Where AttToEx.ExNo='ACCPno001'");
			ResultSet Rs1=e2.executeQuery("SELECT * FROM Exam INNER JOIN AttToEx ON Exam.ExNo = AttToEx.ExNo Where Exam.ExNo='ACCPno001'");
//			while(Rs.next())
			while(Rs.next() && Rs1.next())
			{
				System.out.println(Rs.getString(4));
				System.out.println(Rs.getString(5));
				System.out.println(Rs1.getString(9));
				System.out.println(Rs1.getString(3));
				System.out.println(Rs1.getString(4));
				System.out.println(Rs1.getString(5));
				System.out.println(Rs1.getString(6));
			}

/*			bean=dbBean.GetData("01001");
			System.out.println(bean.getStuID());
			System.out.println(bean.getStuPwd());
			System.out.println(bean.getStuPro());
			String a="01001";
			String b="123456";
			String c="教师";
//			String c="管理员";
			if(a.equals(bean.getStuID()) && b.equals(bean.getStuPwd()) && c.equals(bean.getStuPro()))
				System.out.println("Test is OK!");
			else
				System.out.println("Test is not OK!");
				
			e1=e2.GetOne("ACCPno001");			
			System.out.println(e1.getExNo());
			System.out.println(e1.getExStartTime());

			String id="ACCPst00001";
			String no="ACCPno001";
			double ss=0.00;
			ss=2*100/4;
			System.out.println(ss);
			scoredbBean.executeUpdate("Update AttToEx set pScore="+ss+" Where pNo='"+id+"' and ExNo='"+no+"'");
			
			scoredbBean.GetpNoOne("ACCPno001");
			System.out.println(scoreBean.getPNo());
			System.out.println(scoreBean.getExNo());
			System.out.println(scoreBean.getPScore());
			bean=new AttendmentBean();
			dbBean=new AttendmentDBbean();
//			bean=dbBean.GetOne("ACCPst00001");
			bean=dbBean.GetOne("");*/
/*			int OK=0;
			int flag=0;
			String SubID="";
			String stAns="";
			double Score=0;
			//取出传来的参数信息
			String attID="ACCPst00001";
			//查询试题编号
			ResultSet Rs=s2.executeQuery("SELECT Subject.SubID,Subject.Answer FROM Subject INNER JOIN ExToSub on Subject.SubID=ExToSub.SubID Where ExToSub.ExNo='ACCPno001' Order by OutID");
			//显示记录行
			while(Rs.next())
			{
				flag++;
				//取出试题编号
				int results=Rs.getInt(1);
				SubID=String.valueOf(results);
				//取出试题标准答案
				stAns=Rs.getString(2);
				String subAns="BCD";
				if(stAns.equals(subAns))
					OK++;
				System.out.println("SubID: "+SubID);
				System.out.println("stAns: "+stAns);
			}
			System.out.println("flag: "+flag);
			System.out.println("OK: "+OK);
			//计算考生成绩
			Score=OK*100/flag;
			System.out.println("Score: "+Score);
			//更新考生成绩				
			scoredbBean.executeUpdate("Update AttToEx set pScore="+Score+" Where pNo='"+attID+"' and ExNo='ACCPno001'");
			scoredbBean.Close();
			Rs.close();
			//产生随机数
		   	int temp=0;
		   	int t=0;
		   	int s=0;
		   	String tt=null;					
//			temp = (new Double(Math.random()*997)).intValue();

			ResultSet Rs=a2.executeQuery("SELECT * FROM AttToEx INNER JOIN Attendment ON Attendment.pNo = AttToEx.pNo Where AttToEx.ExNo='ACCPno001'");
//			ResultSet Rs=e2.executeQuery("SELECT * FROM Exam INNER JOIN AttToEx ON Exam.ExNo = AttToEx.ExNo Where Exam.ExNo='ACCPno001'");
				
//			ResultSet Rs=s2.executeQuery("SELECT Subject.SubID,Subject.Answer FROM Subject INNER JOIN ExToSub on Subject.SubID=ExToSub.SubID Where ExToSub.ExNo='ACCPno001' Order by OutID");
			while(Rs.next())
			{
				t=Rs.getInt(1);
				tt=Rs.getString(2);	
				System.out.print(t+"\t");
				System.out.print(tt+"\t");
				temp =(new Double(Math.random()*997)).intValue();
				System.out.print(temp+"\t");
				System.out.print(t*temp+"\t");
				s2.executeUpdate("Update Subject set OutID="+temp+" Where SubID="+t);
				System.out.println();
			}
//			Rs.close();
			System.out.println(bean.getPName());
			System.out.println(bean.getPID());
			System.out.println(bean.getPermitNo());
			a2.Close();	
			aa2.Close();
			e2.Close();	*/
		}
		catch(Exception e)
		{
			System.out.println("测试数据库异常:"+e);
		}
		
	}
}