studentdaobean.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.StudentBean;
import org.adam.dao.StudentDAO;

public class StudentDAOBean implements StudentDAO {

	private DBControl db;
	
	public StudentBean getStudent(int student_id) {
		String sql="select * from student where student_id="+student_id;
		ResultSet rs=db.getDataInfo(sql);
		StudentBean student=new StudentBean();
		try {
			while(rs.next()){
				student.setStudent_id(rs.getInt("student_id"));
				student.setStudentname(rs.getString("studentname"));
				student.setStudentpass(rs.getString("studentpass"));
				student.setStudentemail(rs.getString("studentemail"));
			}
			return student;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return null;
		}finally{
			db.closeConnection();
		}		
	}

	public List<StudentBean> getStudents() {
		String sql="select * from student";
		ResultSet rs=db.getDataInfo(sql);
		StudentBean student;
		List<StudentBean> list=new ArrayList<StudentBean>();
		try {
			while(rs.next()){
				student=new StudentBean();
				student.setStudent_id(rs.getInt("student_id"));
				student.setStudentname(rs.getString("studentname"));
				student.setStudentpass(rs.getString("studentpass"));
				student.setStudentemail(rs.getString("studentemail"));
				list.add(student);
			}
			return list;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return null;
		}finally{
			db.closeConnection();
		}		
	}

	public int studentLogin(StudentBean student) {
		String sql="select * from student where studentemail='"+student.getStudentemail()+"' and studentpass='"+student.getStudentpass()+"'";
		ResultSet rs=db.getDataInfo(sql);
		try {
			if(rs.next()){
				return rs.getInt("student_id");
			}else{
				return 0;
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return 0;
		}finally{
			db.closeConnection();
		}		
	}

	public void studentRegist(StudentBean student) {
		String sql="call addstudent('"+student.getStudentname()+"','"+student.getStudentpass()+"','"+student.getStudentemail()+"')";
		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 studentpass from student where studentname='"+username+"' and studentemail='"+email+"'";
		String password=null;
		ResultSet rs=db.getDataInfo(sql);
		try {
			while(rs.next()){
				password=rs.getString("studentpass");
			}
			return password;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return null;
		}finally{
			db.closeConnection();
		}
	}

}