spedao.java

包含了学生管理系统的一些基本操作以及相关窗口页面实现。

package com.hb.studentmanager.date;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;
import com.hb.studentmanager.connection.ConnectionDateBase;
public class SpeDAO {
	ConnectionDateBase cdb = new ConnectionDateBase();

	Connection con = cdb.getDateBaseConnection();

	PreparedStatement statement = null;

	ResultSet rs = null;

	public void speInsert(SpeDTO dto) {
		String speId = dto.getSpe_id();
		String speName = dto.getSpe_name();
		String sql = "insert into specialty (spe_id,spe_name) values (?,?)";
		try {
			statement = con.prepareStatement(sql);
			statement.setString(1, speId);
			statement.setString(2, speName);
			statement.executeUpdate();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	public void speUpdate(SpeDTO dto) {
		String speId = dto.getSpe_id();
		String speName = dto.getSpe_name();
		String sql = "update specialty set spe_name=? where spe_id=?";
		try {
			statement = con.prepareStatement(sql);
			statement.setString(2, speId);
			statement.setString(1, speName);
			statement.executeUpdate();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	public void speDelete(String id) {
		String speId = id;
		String sql = "delete specialty where spe_id=?";
		try {
			statement = con.prepareStatement(sql);
			statement.setString(1, speId);
			statement.executeUpdate();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	public List speBlurrySelect(SpeDTO dto) {
		List list = new ArrayList();// 得到一个数组
		String speId = dto.getSpe_id();
		String speName=dto.getSpe_name();
		String sql ;
		if(speId.equals("")==false&&speName.equals("")){
			sql= "select *from specialty where spe_id like '%"+speId+"%'";
		}
		else if(speId.equals("")&&speName.equals("")==false){
			sql= "select *from specialty where spe_name like '%"+speName+"%'";
		}
		else{
			sql= "select *from specialty where spe_id like '%"+speId+"%'" +"and spe_name like '%"+speName+"%'";
		}
		try {
			statement = con.prepareStatement(sql);
			rs = statement.executeQuery();
			while (rs.next()) {
				dto = new SpeDTO();
				dto.setSpe_id(rs.getString("spe_id"));// 获得专业代号
				dto.setSpe_name(rs.getString("spe_name"));// 获得专业名称
				list.add(dto);
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
		return list;
	}
	public List speExactSelect(SpeDTO dto) {
		List list = new ArrayList();// 得到一个数组
		String speId = dto.getSpe_id();
		String speName=dto.getSpe_name();
		int flag=0;
		String sql ;
		if(speId.equals("")==false&&speName.equals("")){
			sql= "select *from specialty where spe_id=?";
		}
		else if(speId.equals("")&&speName.equals("")==false){
			sql= "select *from specialty where spe_name=?";
			flag=1;
		}
		else{
			sql= "select *from specialty where spe_id=? and spe_name=?";
			flag=2;
		}
		try {
			statement = con.prepareStatement(sql);
			if(flag==0){
				statement.setString(1, speId);
			}else if(flag==1){
				statement.setString(1,speName);
			}else if(flag==2){
				statement.setString(1, speId);
				statement.setString(2, speName);
			}
			rs = statement.executeQuery();
			while (rs.next()) {
				dto = new SpeDTO();
				dto.setSpe_id(rs.getString("spe_id"));// 获得专业代号
				dto.setSpe_name(rs.getString("spe_name"));// 获得专业名称
				list.add(dto);
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
		return list;
	}
	
	public List selectAll() {
		List list = new ArrayList();// 得到一个数组
		String sql="select *from specialty order by spe_id asc";
		try {
			statement = con.prepareStatement(sql);
			rs = statement.executeQuery();
			while (rs.next()) {
				SpeDTO dto = new SpeDTO();
				dto.setSpe_id(rs.getString("spe_id"));// 获得专业代号
				dto.setSpe_name(rs.getString("spe_name"));// 获得专业名称
				list.add(dto);
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
		return list;
	}
	public List init() {
		List list = new ArrayList();// 得到一个数组
		String sql = "select *from specialty order by spe_id asc";
		try {
			statement = con.prepareStatement(sql);
			rs = statement.executeQuery();
			while (rs.next()) {
				SpeDTO dto = new SpeDTO();
				dto.setSpe_id(rs.getString("spe_id"));// 获得专业代号
				dto.setSpe_name(rs.getString("spe_name"));// 获得专业名称
				list.add(dto);
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
		return list;
	}
}