📄 cladao.java
字号:
package com.hb.studentmanager.date;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import com.hb.studentmanager.connection.ConnectionDateBase;
public class ClaDAO {
ConnectionDateBase cdb=new ConnectionDateBase();
Connection con=cdb.getDateBaseConnection();
/**
* 将添加的信息写入数据库
* @param dto
*/
public void insert(ClaDTO dto)
{
String sql="insert into class (cla_id,tea_id,spe_id) values (?,?,?)";
PreparedStatement stmt;
try
{
stmt=con.prepareStatement(sql);
stmt.setString(1, dto.getCla_id());
stmt.setString(2, dto.getTea_id());
stmt.setString(3, dto.getSpe_id());
stmt.executeUpdate();
}catch(Exception e)
{
e.printStackTrace();
}finally
{
try{
con.close();
}catch(Exception e)
{
e.printStackTrace();
}
}
}
/**
* 将修改的记录更新到数据库中
* @param dto
*/
public void update(ClaDTO dto)
{
String sql="update class set tea_id=?,spe_id=? where cla_id=?";
PreparedStatement stmt;
try
{
stmt=con.prepareStatement(sql);
stmt.setString(1, dto.getTea_id());
stmt.setString(2,dto.getSpe_id());
stmt.setString(3,dto.getCla_id());
stmt.executeUpdate();
}catch(Exception e)
{
e.printStackTrace();
}finally
{
try
{
con.close();
}catch(Exception e)
{
e.printStackTrace();
}
}
}
/**
* 将选中的记录从数据库中删除
* @param claid
*/
public void delete(String claid)
{
String sql="delete from class where cla_id=?";
PreparedStatement stmt;
try
{
stmt=con.prepareStatement(sql);
stmt.setString(1,claid);
stmt.executeUpdate();
}catch(SQLException e)
{
e.printStackTrace();
}
}
/**
* 初始化显示栏
* @return
*/
public List select()
{
List list=new ArrayList();
try
{
PreparedStatement ps=con.prepareStatement("select * from class order by cla_id asc" );
ResultSet rs=ps.executeQuery();
while(rs.next())
{
ClaDTO dto=new ClaDTO();
dto.setCla_id(rs.getString("cla_id"));//获得班级号
dto.setTea_id(rs.getString("tea_id"));//获得班主任编号
dto.setSpe_id(rs.getString("spe_id"));//获得专业代号
list.add(dto);
}
}catch(SQLException e)
{
e.printStackTrace();
}
return list;//返回数组
}
/**
* 取得所有的教师编号
* @return
*/
public List getteaid(){
List list = new ArrayList();
try {
PreparedStatement ps=con.prepareStatement("select tea_id from teacher");
ResultSet rs=ps.executeQuery();
while(rs.next()){
ClaDTO dto =new ClaDTO();
dto.setTea_id(rs.getString("tea_id"));
list.add(dto);//将数组添加到数组中
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return list;
}
/**
* 根据专业名称获取专业代号
* @param spename
* @return
*/
public String getspeid1(String spename)
{
String s=null;
try
{
PreparedStatement ps=con.prepareStatement("select spe_id from specialty where spe_name=?");
ps.setString(1, spename);
ResultSet rs=ps.executeQuery();
while(rs.next())
{
s=rs.getString("spe_id");
}
}catch(Exception e)
{
e.printStackTrace();
}
return s;
}
/**
* 获取所有的专业代号
* @return
*/
public List getspeid(){
List list = new ArrayList();
try {
PreparedStatement ps=con.prepareStatement("select spe_id from specialty");
ResultSet rs=ps.executeQuery();
while(rs.next()){
ClaDTO dto =new ClaDTO();
dto.setSpe_id(rs.getString("spe_id"));
list.add(dto);//将数组添加到数组中
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return list;
}
/**
* 获取所有专业名称
* @return
*/
public List getspename()
{
List list=new ArrayList();
try
{
PreparedStatement ps=con.prepareStatement("select spe_name from specialty");
ResultSet rs=ps.executeQuery();
while(rs.next())
{
ClaDTO dto=new ClaDTO();
dto.setSpe_name(rs.getString("spe_name"));
list.add(dto);
}
}catch(SQLException e)
{
e.printStackTrace();
}
return list;
}
/**
* 根据班级编号查出记录的其他属性
* @param claid
* @return
*/
public List select1(String claid)
{
List list=new ArrayList();
try
{
PreparedStatement ps=con.prepareStatement("select * from class where cla_id=?");
ps.setString(1, claid);
ResultSet rs=ps.executeQuery();
while(rs.next())
{
ClaDTO dto=new ClaDTO();
dto.setSpe_id(rs.getString("spe_id"));
dto.setTea_id(rs.getString("tea_id"));
dto.setCla_id(claid);
list.add(dto);
}
}catch(SQLException e)
{
e.printStackTrace();
}
return list;
}
public List select2(String claid)
{
List list=new ArrayList();
try
{
PreparedStatement ps=con.prepareStatement("select * from class where cla_id like '%"+claid+"%'");
ResultSet rs=ps.executeQuery();
while(rs.next())
{
ClaDTO dto=new ClaDTO();
dto.setSpe_id(rs.getString("spe_id"));
dto.setTea_id(rs.getString("tea_id"));
dto.setCla_id(rs.getString("cla_id"));
list.add(dto);
}
}catch(SQLException e)
{
e.printStackTrace();
}
return list;
}
/**
* 进行综合查询
* @param claid
* @param spename
* @param teaid
* @param teaname
* @return
*/
public List select3(String claid,String spename,String teaid,String teaname)
{
List list=new ArrayList();
try
{
PreparedStatement ps=con.prepareStatement("select * from spe_cla where spe_name like '%"+spename+"%' and tea_id like '%"+teaid+"%' and tea_name like '%"+teaname+"%' and cla_id like '%"+claid+"%'");
ResultSet rs=ps.executeQuery();
while(rs.next())
{
ClaDTO dto=new ClaDTO();
dto.setSpe_id(rs.getString("spe_id"));
dto.setTea_id(rs.getString("tea_id"));
dto.setCla_id(rs.getString("cla_id"));
list.add(dto);
}
}catch(SQLException e)
{
e.printStackTrace();
}
return list;
}
/**
* 进行总和查询
* @param claid
* @param teaid
* @param teaname
* @return
*/
public List select4(String claid,String teaid,String teaname)
{
List list=new ArrayList();
try
{
PreparedStatement ps=con.prepareStatement("select * from tea_cla where tea_id like '%"+teaid+"%' and tea_name like '%"+teaname+"%' and cla_id like '%"+claid+"%'");
ResultSet rs=ps.executeQuery();
while(rs.next())
{
ClaDTO dto=new ClaDTO();
dto.setSpe_id(rs.getString("spe_id"));
dto.setTea_id(rs.getString("tea_id"));
dto.setCla_id(rs.getString("cla_id"));
list.add(dto);
}
}catch(SQLException e)
{
e.printStackTrace();
}
return list;
}
/**
* 根据输入的claid及spename进行查询
* @param claid
* @param spename
* @return
*/
public List select5(String claid,String spename)
{
List list=new ArrayList();
try
{
PreparedStatement ps=con.prepareStatement("select * from spename where spe_name like '%"+spename+"%' and cla_id like '%"+claid+"%'");
ResultSet rs=ps.executeQuery();
while(rs.next())
{
ClaDTO dto=new ClaDTO();
dto.setCla_id(rs.getString("cla_id"));//获得班级号
dto.setTea_id(rs.getString("tea_id"));//获得班主任编号
dto.setSpe_id(rs.getString("spe_id"));//获得专业代号
list.add(dto);
}
}catch(SQLException e)
{
e.printStackTrace();
}
return list;
}
/**
* 根据teaid进行教师姓名的查询
* @param teaid
* @return
*/
public String getteaname1(String teaid)
{
String s=null;
try
{
PreparedStatement ps=con.prepareStatement("select tea_name from teacher where tea_id=?");
ps.setString(1, teaid);
ResultSet rs=ps.executeQuery();
while(rs.next())
{
s=rs.getString("tea_name");
}
}catch(Exception e)
{
e.printStackTrace();
}
return s;
}
/**
* 根据专业代号查询专业名称
* @param speid
* @return
*/
public String getspename1(String speid)
{
String s=null;
try{
PreparedStatement ps=con.prepareStatement("select spe_name from specialty where spe_id=?");
ps.setString(1, speid);
ResultSet rs=ps.executeQuery();
while (rs.next())
{
s=rs.getString("spe_name");
}
}catch(Exception e)
{
e.printStackTrace();
}
return s;
}
/**
* 根据输入进行综合查询
* @param claid
* @param date
* @param sta
* @return
*/
public List selectcladuty(String claid,String date,String sta)
{
List list=new ArrayList();
try
{
PreparedStatement ps=con.prepareStatement("select * from claduty where cla_id like '%"+claid+"%' and dut_date like '%"+date+"%' and dut_sta like '%"+sta+"%'");
ResultSet rs=ps.executeQuery();
while(rs.next())
{
DutyDTO dto=new DutyDTO();
dto.setStu_id(rs.getString("stu_id"));
dto.setStu_name(rs.getString("stu_name"));
dto.setDut_date(rs.getString("dut_date"));
dto.setDut_sta(rs.getString("dut_sta"));
list.add(dto);
}
}catch(Exception e)
{
e.printStackTrace();
}
return list;
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -