teacherregistbean.java

基于Spring2.5的精品课程网站

package org.adam.dao.impl;

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


import org.adam.DataSource.DBControl;
import org.adam.bean.TeacherBean;
import org.adam.dao.TeacherRegist;

public class TeacherRegistBean implements TeacherRegist {

	private DBControl db;
		
	public TeacherBean getTeacher(int teacher_id) {
		String sql="select * from teacher where teacher_id="+teacher_id;
		ResultSet rs=db.getDataInfo(sql);
		TeacherBean teacher=new TeacherBean();
		try {
			while(rs.next()){
				teacher.setTeacher_id(rs.getInt("teacher_id"));
				teacher.setTeachername(rs.getString("teachername"));
				teacher.setTeacherpass(rs.getString("teacherpass"));
				teacher.setTeacheremail(rs.getString("teacheremail"));
				teacher.setState(rs.getInt("state"));
			}
			return teacher;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return null;
		}finally{
			db.closeConnection();
		}
		
	}

	public List<TeacherBean> getTeachers() {
		String sql="select * from teacher where state=1";
		ResultSet rs=db.getDataInfo(sql);
		List<TeacherBean> list=new ArrayList<TeacherBean>();
		try {
			while(rs.next()){
				TeacherBean teacher=new TeacherBean();
				teacher.setTeacher_id(rs.getInt("teacher_id"));
				teacher.setTeachername(rs.getString("teachername"));
				teacher.setTeacherpass(rs.getString("teacherpass"));
				teacher.setTeacheremail(rs.getString("teacheremail"));
				teacher.setState(rs.getInt("state"));
				list.add(teacher);
			}
			return list;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return null;
		}finally{
			db.closeConnection();
		}
	}

	public int login(TeacherBean teacher) {
		String sql="select * from teacher where teacheremail='"+teacher.getTeacheremail()+"' and teacherpass='"+teacher.getTeacherpass()+"' and state=1";
		ResultSet rs=db.getDataInfo(sql);
		try {
			if(rs.next()){
				return rs.getInt("teacher_id");
			}else{
				return 0;
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return 0;
		}finally{
			db.closeConnection();
		}		
	}

	public void regist(TeacherBean teacher) {
		String sql="call addteacher('"+teacher.getTeachername()+"','"+teacher.getTeacheremail()+"','"+teacher.getTeacherpass()+"',"+teacher.getState()+")";
		db.setDataInfo(sql);
	}

	public void updateState(TeacherBean teacher) {
		String sql="update teacher set state=1 where teacher_id="+teacher.getTeacher_id();
		db.setDataInfo(sql);
	}

	public DBControl getDb() {
		return db;
	}

	public void setDb(DBControl db) {
		this.db = db;
	}

	public String getPassword(String username, String email) {
		String sql="select teacherpass from teacher where teachername='"+username+"' and teacheremail='"+email+"'";
		String password=null;
		ResultSet rs=db.getDataInfo(sql);
		try {
			while(rs.next()){
				password=rs.getString("teacherpass");
			}
			return password;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return null;
		}finally{
			db.closeConnection();
		}
	}

	public List<TeacherBean> getMessages(int nowpage, int pagecount) {
		String sql="select * from teacher where state=0 limit "+(nowpage-1)*pagecount+","+pagecount;
		ResultSet rs=db.getDataInfo(sql);
		List<TeacherBean> list=new ArrayList<TeacherBean>();
		try {
			while(rs.next()){
				TeacherBean teacher=new TeacherBean();
				teacher.setTeacher_id(rs.getInt("teacher_id"));
				teacher.setTeachername(rs.getString("teachername"));
				teacher.setTeacherpass(rs.getString("teacherpass"));
				teacher.setTeacheremail(rs.getString("teacheremail"));
				teacher.setState(rs.getInt("state"));
				list.add(teacher);
			}
			return list;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return null;
		}finally{
			db.closeConnection();
		}
	}

	public void updateState(String[] teacher_id) {
		int length=teacher_id.length;
		String sql=null;
		String sql2=new String();
		String sql1="update teacher set state=1 where teacher_id in(";
		for(int j=0;j<length;j++){
			sql2=teacher_id[j]+" ,"+sql2;
		}
		sql=sql1+sql2;		
		sql=sql.substring(0,sql.length()-1)+")";
		db.setDataInfo(sql);
	}

	public int getTeachersCount() {
		String sql="select count(teacher_id) as id from teacher";
		int number=0;
		ResultSet rs=db.getDataInfo(sql);
		try {
			while(rs.next()){
				number=rs.getInt("id");
			}
			return number;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return 0;
		}finally{
			db.closeConnection();
		}
	}

}