data.java

基于Java实现的聊天室功能

package Date;

import java.sql.*;
import java.util.ArrayList;

import shujuku.College;
import shujuku.Course;
import shujuku.Dep;
import shujuku.Student;
import shujuku.Teacher;

public class Data{
	private Conn conn = new Conn();
	private Statement stmt;
	private ResultSet rs;
	public Data(){}
	
	public int Login(String sql){
		int result = 0;
		
		stmt = conn.getStmt();
		try {
			rs = stmt.executeQuery(sql);
		    if(rs.next())result=1;
		} catch (SQLException e) {
			e.printStackTrace();
			result = -1;
		}
		conn.close();
		return result;
	}
	
	public ArrayList<Teacher> getTeacherList(String sql){
		ArrayList<Teacher> list = new ArrayList<Teacher>();
		stmt = conn.getStmt();
		try{
			rs = stmt.executeQuery(sql);
			Teacher teacher = null;
			while(rs.next()){
				teacher = new Teacher();
				teacher.setTeacher_ID(rs.getString("Teacher_ID"));
				teacher.setTeacher_name(rs.getString("Teacher_name"));
				teacher.setTeacher_password(rs.getString("Teacher_password"));
				teacher.setTeacher_sex(rs.getString("Teacher_sex"));
				teacher.setTeacher_college(rs.getString("College_name"));
				teacher.setTeacher_dep(rs.getString("Dep_name"));
				list.add(teacher);
			}
		}catch(SQLException e){
			e.printStackTrace();
		}
		conn.close();
		return list;
	}
	
	public ArrayList<Student> getStudentList(String sql){
		ArrayList<Student> list = new ArrayList<Student>();
		stmt = conn.getStmt();
		try{
			rs = stmt.executeQuery(sql);
			Student student = null;
			while(rs.next()){
				student = new Student();
				student.setStu_ID(rs.getString("Stu_ID"));
				student.setStu_password(rs.getString("Stu_password"));
				student.setStu_name(rs.getString("Stu_name"));
				student.setStu_sex(rs.getString("Stu_sex"));
				student.setStu_college(rs.getString("College_name"));
				student.setStu_dep(rs.getString("Dep_name"));
				student.setStu_class(rs.getString("Stu_class"));
				student.setStu_major(rs.getString("Stu_major"));
				list.add(student);
			}
		}catch(SQLException e){
			e.printStackTrace();
		}
		conn.close();
		return list;
	}
	
	public ArrayList<College> getCollegeAndDep(){
		ArrayList<College> list = new ArrayList<College>();
		stmt = conn.getStmt();
		try{
			rs = stmt.executeQuery("select College_ID,College_name,Dep_ID,Dep_name,Dep_college_ID from college," +
					"dep");
			College college = null;
			Dep dep = null;
			boolean flag = true;
			while(rs.next()){
				flag = true;
				for(int i=0;i<list.size();i++){
					if(list.get(i).getCollege_ID().equals(rs.getString("College_ID"))){
						flag = false;
						college = list.get(i);
						break;
					}
				}
				if(flag){
					college = new College();
					college.setCollege_ID(rs.getString("College_ID"));
					college.setCollege_name(rs.getString("College_name"));
					list.add(college);
				}
				if(rs.getString("Dep_college_ID").equals(college.getCollege_ID())){
				    dep = new Dep();
				    dep.setDep_ID(rs.getString("Dep_ID"));
				    dep.setDep_college_ID(college.getCollege_ID());
				    dep.setDep_name(rs.getString("Dep_name"));
				    college.getDepList().add(dep);
				}
			}
		}catch(SQLException e){
			e.printStackTrace();
		}
		conn.close();
		return list;
	}
	
	public boolean XiuGaiMiMa(String sql){
		boolean result = false;
		stmt = conn.getStmt();
		try{
			stmt.executeUpdate(sql);
			result = true;
		}catch(SQLException e){
			e.printStackTrace();
			result = false;
		}
		conn.close();
		return result;
	}
	
	public boolean addInof(String sql){
		boolean result =false;
		stmt = conn.getStmt();
		try{
			stmt.executeUpdate(sql);
			result = true;
		}catch(SQLException e){
			e.printStackTrace();
			result = false;
		}
		conn.close();
		return result;
	}
	
	public ArrayList<Course> getCourseList(String sql){
		ArrayList<Course> list = new ArrayList<Course>();
		stmt = conn.getStmt();
		try{
			rs = stmt.executeQuery(sql);
			Course course = null;
			while(rs.next()){
				course = new Course();
				course.setStu_ID(rs.getString("Stu_ID"));
				course.setCourse_ID(rs.getString("Course_ID"));
				course.setCourse_name(rs.getString("Course_name"));
				course.setCourse_num(rs.getString("Course_num"));
				course.setTeacher_name(rs.getString("Teacher_name"));
				course.setCourse_grade(rs.getString("Course_grade"));
				list.add(course);
			}
		}catch(SQLException e){
			e.printStackTrace();
		}
		conn.close();
		return list;
	}
	
	public ArrayList<Course> getCourse(String sql){
		ArrayList<Course> list = new ArrayList<Course>();
		stmt = conn.getStmt();
		try{
			rs = stmt.executeQuery(sql);
			Course course = null;
			while(rs.next()){
				course = new Course();
				course.setCourse_ID(rs.getString("Course_ID"));
				course.setCourse_name(rs.getString("Course_name"));
				course.setCourse_num(rs.getString("Course_num"));
				course.setTeacher_name(rs.getString("Teacher_name"));
				list.add(course);
			}
		}catch(SQLException e){
			e.printStackTrace();
		}
		conn.close();
		return list;
	}
	
	public static void main(String[] args){
		Data data = new Data();
		data.getCollegeAndDep();
	}
}