util.java

旅游管理系统

package com.bjfu.tm;

import java.security.*;
import java.security.spec.*; 
import java.math.BigInteger;
import java.util.*;
import java.sql.*;
import java.util.Date;

public class Util {
	public Util(){}
	public static String TextToHtml(String sourcestr) 
	{ 
	int strlen; 
	String restring="", destr = ""; 
	strlen = sourcestr.length(); 
	for (int i=0; i<strlen; i++) 
	{ 
	char ch=sourcestr.charAt(i); 
	switch (ch) 
	{ 
	case '<': 
	destr = "&lt;"; 
	break; 
	case '>': 
	destr = "&gt;"; 
	break; 
	case '\"': 
	destr = "&quot;"; 
	break; 
	case '&': 
	destr = "&amp;"; 
	break; 
	case 13: 
	destr = "<br/>"; 
	break; 
	case 32: 
	destr = "&nbsp;"; 
	break; 
	case '\'':
        destr ="‘";
	break;
	default : 
	destr = "" + ch; 
	break; 
	} 
	restring = restring + destr; 
	} 
	return "" + restring; 
	} 
	
	public String inText(String str)
	{
		String sTemp;
		sTemp = str;
		if(sTemp.equals(""))
		{
			System.exit(0);
		}
		sTemp = sTemp.replaceAll("&amp;", "&");
		sTemp = sTemp.replaceAll("&lt;", "<");
		sTemp = sTemp.replaceAll("&gt;", ">");
		sTemp = sTemp.replaceAll("&quot;", "\"");
		sTemp = sTemp.replaceAll("<br/>", "");
		sTemp = sTemp.replaceAll("&nbsp;", " ");	
		return sTemp;
	}
	
	public String MD5(String sInput)throws Exception{

		String algorithm="";
		//输入不能为空 
		if(sInput.trim()==null){
				return "null";
		} 

		//指定采用MD5算法
		try{
				algorithm=System.getProperty("MD5.algorithm","MD5");
		}catch(SecurityException se){
		}

		//定义MessageDigest对象
		MessageDigest md=MessageDigest.getInstance(algorithm);

		//按照系统缺省的字符编码方式把sInput 转换成字节，并把结果存到一新的字节数组buffer中
		byte buffer[]=sInput.getBytes();

		//从指定的字节数组buffer的偏移量0开始，用指定的字节数组修改由sInput生成摘要
		//count为从 0 开始用的字节数长度。 
		for(int count=0;count<sInput.length();count++){ 
				md.update(buffer,0,count);
		}

		//通过执行最后的诸如填充的操作完成散列码的计算。 在调用之后复位该摘要
		//返回存放结果散列值的字节数组bDigest
		byte bDigest[]=md.digest();

		//将bDigest转换为大整数bi
		BigInteger bi=new BigInteger(bDigest);

		//返回bi字符串表示，即最终的编码结果
		return(bi.toString(16)); 
	}
	/*
	*format Date
	public String StrToDate(String inDate){
		String outDate = null;
		SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
		outDate = sdf(inDate);
		System.out.print(outDate); 
		return outDate;
	}*/
	/*
	 * 获取日期表的的年份值
	 */
	public int getYear() throws Exception{
	
		int cn = 0;
		try{
				DbConn dc = new DbConn();
				dc.OpenConn();
				ResultSet rs = null;
				String sql = null;

				sql = "select * from SelDate";
				rs = dc.select(sql);
				if(rs.next()){
					cn = rs.getInt("selYear");	
				}
				rs.close();
				dc.close();
		}catch(Exception e	){
				System.out.println(e.getMessage());
		}
		return cn; 
		
	}
	/*
	 * 获得当前用户的ID号
	 */
	public int getID(String colName,String dbName) throws Exception{
		
		int id = 0;
		try{
				DbConn dc = new DbConn();
				dc.OpenConn();
				ResultSet rs = null;
				String sql = null;

				if(dbName.equals("Teacher")){
						sql = "select tea_ID from Teacher where tNumber=" + "'" + colName + "'";
						rs = dc.select(sql);
						while(rs.next()){
								id = rs.getInt("tea_ID");		
						}

				}else if(dbName.equals("Student")){
						sql = "select stu_ID from Student where sNumber=" + "'" + colName + "'";
						rs = dc.select(sql);
						while(rs.next()){
							id = rs.getInt("stu_ID");		
						}	
				}else {
					return -1;
				}
				rs.close();
				dc.close();
		}catch(Exception e	){
				System.out.println(e.getMessage());
		}
		return id; 
		
	}
	/*
	 * 获取当前学生ID的选题值，返回int
	 */
	public int getStuSelNum(int ID) {
		int sel = 0;
		try{
			DbConn dc = new DbConn();
			dc.OpenConn();
			ResultSet rs = null;
			String sql = null;

			sql = "select sel_number from Student where stu_ID=" + "'" + ID + "'";
			rs = dc.select(sql);
			if(rs.next()){
				sel = rs.getInt("sel_number");
			}	
			rs.close();
			dc.close();
		}catch(Exception e){
			System.out.println(e.getMessage());
		}
		return sel;
	}
	/*
	 * 获取当前题目的老师标识，返回int
	 */
	public int getSubTeaNum(int ID) {
		int tea = 0;
		try{
			DbConn dc = new DbConn();
			dc.OpenConn();
			ResultSet rs = null;
			String sql = null;

			sql = "select teaflag from Subject where sub_ID=" + "'" + ID + "'";
			rs = dc.select(sql);
			if(rs.next()){
				tea = rs.getInt("teaflag");
			}	
			rs.close();
			dc.close();
		}catch(Exception e){
			System.out.println(e.getMessage());
		}
		return tea;
	}
	/*
	 * 获取当前ID学生的选题标识，返回boolean
	 */
	public boolean getStuSelFlag(int ID) {
		boolean sel = false;
		try{
			DbConn dc = new DbConn();
			dc.OpenConn();
			ResultSet rs = null;
			String sql = null;

			sql = "select sel_flag from Student where stu_ID=" + "'" + ID + "'";
			rs = dc.select(sql);
			if(rs.next()){
				if(rs.getInt("sel_flag")==0){
					sel = false;
				}else if(rs.getInt("sel_flag")==1) {
					sel = true;
				}
			}		
			rs.close();
			dc.close();
		}catch(Exception e){
			System.out.println(e.getMessage());
		}
		return sel;
	}
	/*
	 * 获取老师表的名字字段
	 */
	public String getName(int colNum) throws Exception{
	
		String name = null;
		try{
				DbConn dc = new DbConn();
				dc.OpenConn();
				ResultSet rs = null;
				String sql = null;

				sql = "select tName from Teacher where tea_ID='" + colNum + "'";
				rs = dc.select(sql);
				if(rs.next()){
					name = rs.getString("tName");	
				}
				
				rs.close();
				dc.close();
		}catch(Exception e	){
				System.out.println(e.getMessage());
		}
		return name; 
		
	}
	/*
	 * 比较日期，确定是否是教师设置题目时间
	 */
	public boolean DefTeaDate(int year) {
		
		boolean def = false;
		Calendar calNow = Calendar.getInstance();
		Calendar calBegin = Calendar.getInstance();
		Calendar calEnd = Calendar.getInstance();
		long timeNow=0,timeBegin = 0, timeEnd = 0;
		calNow.setTime(new java.util.Date());
		try{
			DbConn dc = new DbConn();
			dc.OpenConn();
			ResultSet rs = null;
			String sql = null;
			
			sql = "select * from SelDate where selYear='" + year + "'";
			rs = dc.select(sql);
			if(!rs.next()) {
				return false;
			}else {
				do {
					calBegin.setTime(rs.getDate("teaBeginDate"));
					calEnd.setTime(rs.getDate("teaEndDate"));
				}while(rs.next());
			}
			timeNow = calNow.getTimeInMillis();
			timeBegin = calBegin.getTimeInMillis();
			timeEnd = calEnd.getTimeInMillis();
			
			if((timeNow-timeBegin)>0&&(timeEnd - timeNow)>0) {
				def = true;
			}else {
				def = false;
			}
			rs.close();
			dc.close();
		}catch(Exception e	){
			System.out.println(e.getMessage());
		}
		return def;
		
	}
	/*
	 * 比较日期，确定是否是学生选题时间
	 */
	public boolean DefStuDate(int year) {
		
		boolean def = false;
		Calendar calNow = Calendar.getInstance();
		Calendar calBegin = Calendar.getInstance();
		Calendar calEnd = Calendar.getInstance();
		long timeNow=0,timeBegin = 0, timeEnd = 0;
		calNow.setTime(new java.util.Date());
		try{
			DbConn dc = new DbConn();
			dc.OpenConn();
			ResultSet rs = null;
			String sql = null;
			
			sql = "select * from SelDate where selYear='" + year + "'";
			rs = dc.select(sql);
			if(!rs.next()) {
				return false;
			}else {
				do {
					calBegin.setTime(rs.getDate("stuBeginDate"));
					calEnd.setTime(rs.getDate("stuEndDate"));
				}while(rs.next());
			}
			timeNow = calNow.getTimeInMillis();
			timeBegin = calBegin.getTimeInMillis();
			timeEnd = calEnd.getTimeInMillis();
			
			if((timeNow-timeBegin)>0&&(timeEnd - timeNow)>0) {
				def = true;
			}else {
				def = false;
			}
			rs.close();
			dc.close();
		}catch(Exception e	){
			System.out.println(e.getMessage());
		}
		return def;
		
	}
	/*
	 * 随机选人操作
	 */
	public void RandSel(int subNum,int sublimit,int selCount) {
		try{
			DbConn dc = new DbConn();
			dc.OpenConn();
			ResultSet rs = null;
			ArrayList list = new ArrayList();
			String sql = null;
			int ct = selCount - sublimit;
			
			//取出题号为subNum的所有学生
			sql = "select * from Student where sel_number='" + subNum + "'";
					
			rs = dc.select(sql);
			
			System.out.print("sql="+sql);
			while(rs.next()) {
				list.add(Integer.valueOf(rs.getInt("stu_ID")));
				
				/*sql = "update Student set sel_flag = 0,sel_number=0,tea_flag=0 where stu_ID ='" + rs.getInt("stu_ID") +"' and sel_flag = 1";
				dc.update(sql);
				dc.OpenConn();
				ct--;
				*/
			}
			sql = "update Subject set sub_count=limit";
			dc.update(sql);			
			
			rs.close();
			dc.close();
		}catch(Exception e	){
			System.out.println(e.getMessage());
		}
		
	}
}