selinfo.java

一个真实的网络选课系统,由实际需求得到的,本人实际开发出来,运用JSP+TOMCAT

package com;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

import log.CreateLogs;

public class SelInfo {
	public static String[] getInfo()
	{
		String SelInfo[]=new String[84];
		for(int i=0;i<84;i++)
		{
			SelInfo[i]=null;
		}
		JDBConnection db=new JDBConnection();
		String query="SELECT t_week, t_hour, name FROM userInfo AS a, selectInfo AS b WHERE b.v_date="+Value.getValue(new Date())+ "and a.stdno=b.stdno";
		System.out.println(Value.getValue(new Date()));
		ResultSet rs=db.executeQuery(query);
		int i,j;
		try{
		while(rs.next())
		{
			i=rs.getInt("t_week");
			j=rs.getInt("t_hour");
			SelInfo[i+j*7]=rs.getString("name");
		}
		db.closeConnection();
		}
		catch (SQLException e) {
			CreateLogs.createLog(e, "SelInfo.java");
	         System.out.println("获取排课信息失败");
	         System.out.println(e.getMessage());
	    }
		
		return SelInfo;
	}
	
	public static String[] getInfo2()
	{
		String SelInfo[]=new String[84];
		for(int i=0;i<84;i++)
		{
			SelInfo[i]=null;
		}
		JDBConnection db=new JDBConnection();
		String query="SELECT t_week, t_hour, name FROM userInfo AS a, selectInfo AS b WHERE b.v_date="+Value.getValue2(new Date())+ "and a.stdno=b.stdno";
		ResultSet rs=db.executeQuery(query);
		int i,j;
		try{
		while(rs.next())
		{
			i=rs.getInt("t_week");
			j=rs.getInt("t_hour");
			SelInfo[i+j*7]=rs.getString("name");
		}
		db.closeConnection();
		}
		catch (SQLException e) {
			CreateLogs.createLog(e, "SelInfo.java");
	         System.out.println("获取排课信息失败");
	         System.out.println(e.getMessage());
	    }
		
		return SelInfo;
	}
	public static boolean[] getWeekTF()
	{
		boolean WeekTF[]=new boolean[7];
		for(int i=0;i<7;i++)
		{
			WeekTF[i]=true;
		}
		JDBConnection db=new JDBConnection();
		String query="SELECT t_week from weekInfo  WHERE wkvalue=false and v_date="+Value.getValue(new Date());
		ResultSet rs=db.executeQuery(query);
		int i;
		try{
		while(rs.next())
		{
			i=rs.getInt("t_week");
			
			WeekTF[i]=false;
		}
		db.closeConnection();
		}
		catch (SQLException e) {
			CreateLogs.createLog(e, "SelInfo.java");
	         System.out.println("获取是否上课信息失败");
	         System.out.println(e.getMessage());
	    }
		
		return WeekTF;
		
	}
	
	public static boolean[] getWeekTF2()
	{
		boolean WeekTF[]=new boolean[7];
		for(int i=0;i<7;i++)
		{
			WeekTF[i]=true;
		}
		JDBConnection db=new JDBConnection();
		String query="SELECT t_week from weekInfo  WHERE wkvalue=false and v_date="+Value.getValue2(new Date());
		ResultSet rs=db.executeQuery(query);
		int i;
		try{
		while(rs.next())
		{
			i=rs.getInt("t_week");
			
			WeekTF[i]=false;
		}
		db.closeConnection();
		}
		catch (SQLException e) {
			CreateLogs.createLog(e, "SelInfo.java");
	         System.out.println("获取是否上课信息失败");
	         System.out.println(e.getMessage());
	    }
		
		return WeekTF;
		
	}
	
	public static List getPerson()
	{
		List<Person> personlist=new ArrayList<Person>();
		personlist.clear();
		JDBConnection db=new JDBConnection();
		String query="select * from userInfo";
		ResultSet rs=db.executeQuery(query);
		try{
			while(rs.next())
			{
				
				personlist.add(new Person(rs.getString("stdno"),rs.getString("name")));	
			}
			db.closeConnection();
			}
			catch (SQLException e) {
				CreateLogs.createLog(e, "SelInfo.java");
		         System.out.println("获取学生信息失败");
		         System.out.println(e.getMessage());
		    }
			return personlist;
	}
}