studentdao.java

利用SQLServer2000实现学生管理系统！

package com.yhf.student;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import com.yhf.beans.CreateConnection;

public class StudentDAO {
	Connection conn;
	private Statement stmt;
	public StudentDAO() throws SQLException{
		conn=CreateConnection.conn;
		stmt=conn.createStatement();
	}
	
	public boolean insert(StudentBean stuBean) throws SQLException{
		String sql="insert into students values('" +
				stuBean.getSName() + "'," +
				stuBean.getSAge() + ",'" +
				stuBean.getSTel() + "','" + 
				stuBean.getSSex() + "','" + 
				stuBean.getSEmail() + "','" + 
				stuBean.getSAddress() + "')";
		int index=stmt.executeUpdate(sql);
		if(index>0){
			return true;
		}else{
			return false;
		}
				
	}
	
	public boolean update(StudentBean stuBean) throws SQLException{
		String sql="update students set name='" + stuBean.getSName() +
					"', age=" + stuBean.getSAge() + 
					" , tel='" + stuBean.getSTel() + 
					"', sex='" + stuBean.getSSex() + 
					"', email='" + stuBean.getSEmail() +
					"', address='" + stuBean.getSAddress() +
					"' where id=" + stuBean.getId();
		System.out.println("sql=" + sql);
		int index=stmt.executeUpdate(sql);
		if(index>0){
			return true;
		}else{
			return false;
		}
	}
	
	public boolean delete(int id) throws SQLException{
		String sql="delete students where id=" + id;
		int index=stmt.executeUpdate(sql);
		if(index>0){
			return true;
		}else{
			return false;
		}
	}
	
	public StudentBean findById(int id) throws SQLException{
		String sql="select * from students where id=" + id;
		ResultSet rs=this.stmt.executeQuery(sql);
		if(rs.next()){
			StudentBean stuBean=new StudentBean();
			stuBean.setId(rs.getInt("id"));
			stuBean.setSName(rs.getString("name"));
			stuBean.setSAge(rs.getInt("age"));
			stuBean.setSTel(rs.getString("tel"));
			stuBean.setSSex(rs.getString("sex"));
			stuBean.setSEmail(rs.getString("email"));
			stuBean.setSAddress(rs.getString("address"));
			
			return stuBean;
		}
		return null;
	}
	
	public List findAll() throws SQLException{
		String sql="select * from students";
		ResultSet rs=stmt.executeQuery(sql);
		List stuList=new ArrayList();
		while(rs.next()){
			StudentBean stuBean=new StudentBean();
			stuBean.setId(rs.getInt("id"));
			stuBean.setSName(rs.getString("name"));
			stuBean.setSAge(rs.getInt("age"));
			stuBean.setSTel(rs.getString("tel"));
			stuBean.setSSex(rs.getString("sex"));
			stuBean.setSEmail(rs.getString("email"));
			stuBean.setSAddress(rs.getString("address"));
			
			stuList.add(stuBean);
		}
		return stuList;
	}
	
	public List findByName(String stuName) throws SQLException{
		String sql="select * from students where name='" + stuName + "'";
		ResultSet rs=stmt.executeQuery(sql);
		List stuList=new ArrayList();
		while(rs.next()){
			StudentBean stuBean=new StudentBean();
			stuBean.setId(rs.getInt("id"));
			stuBean.setSName(rs.getString("name"));
			stuBean.setSAge(rs.getInt("age"));
			stuBean.setSTel(rs.getString("tel"));
			stuBean.setSSex(rs.getString("sex"));
			stuBean.setSEmail(rs.getString("email"));
			stuBean.setSAddress(rs.getString("address"));
			
			stuList.add(stuBean);
		}
		return stuList;
	}
}