📄 claaction.java
字号:
package com.hb.studentmanager.action;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;
import java.util.Vector;
import javax.swing.DefaultComboBoxModel;
import javax.swing.JFrame;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;
import com.hb.studentmanager.date.*;
import com.hb.studentmanager.ui.ClaAddFrame;
import com.hb.studentmanager.ui.ClaUpdateFrame;
public class ClaAction {
ClaDTO dto= new ClaDTO();
ClaDAO dao= new ClaDAO();
DutyDTO dto1=new DutyDTO();
/**
* 进行各种查询显示到表上的页数的计算
* @param claid
* @param spename
* @param teaid
* @param teaname
* @return
*/
public int page(String claid,String spename,String teaid,String teaname)
{
int page=1;
int count=0;
List list=new ArrayList();
if(claid.equals("")&&teaid.equals("")&&teaname.equals("")&&spename.equals(""))
{
list=dao.select();
}
else
{
if(!claid.equals("")&&teaid.equals("")&&teaname.equals("")&&spename.equals(""))
{
list=dao.select2(claid);
}
else
{
if(spename.equals(""))
{
list=dao.select4(claid,teaid, teaname);
}
else
{
if(teaid.equals("")&&teaname.equals(""))
{
list=dao.select5(claid,spename);
}
else
{
list=dao.select3(claid,spename, teaid, teaname);
}
}
}
}
Iterator it=list.iterator();
if(list.isEmpty())
{
page=1;
}
else
{
while(it.hasNext())
{
it.next();
count++;
}
if(count%5==0)
page=count/5;
else
page=count/5+1;
}
return page;
}
/**
* 进行添加操作时判断班级号是否重复
* @param claid
* @return
*/
public boolean compare1(String claid)
{
boolean flag=false;
List list=dao.select();
Iterator it=list.iterator();
while(it.hasNext())
{
dto=(ClaDTO)it.next();
if(dto.getCla_id().equals(claid))
{
flag=true;
}
}
return flag;
}
/**
* 进行不同输入的查询
* @param claid
* @param spename
* @param teaid
* @param teaname
* @param dtm
* @param page
*/
public void select(String claid,String spename,String teaid,String teaname,DefaultTableModel dtm,int page)
{
List list=new ArrayList();
if(claid.equals("")&&teaid.equals("")&&teaname.equals("")&&spename.equals(""))
{
list=dao.select();
}
else
{
if(!claid.equals("")&&teaid.equals("")&&teaname.equals("")&&spename.equals(""))
{
list=dao.select2(claid);
}
else
{
if(spename.equals(""))
{
list=dao.select4(claid,teaid, teaname);
}
else
{
if(teaid.equals("")&&teaname.equals(""))
{
list=dao.select5(claid,spename);
}
else
{
list=dao.select3(claid,spename, teaid, teaname);
}
}
}
}
Iterator it=list.iterator();
if(list.isEmpty())
{
for(int i=1;i<6;i++)
{
Vector vt=new Vector();
vt.add("");
vt.add("");
vt.add("");
vt.add("");
dtm.addRow(vt);
}
}
else
{
for(int i=0;i<(page-1)*5;i++){
it.next();
}
while(it.hasNext())
{
Vector vt=new Vector();
dto=(ClaDTO)it.next();
vt.add(dto.getCla_id());
vt.add(dto.getTea_id());
if(dto.getTea_id()!=null)
{
vt.add(dao.getteaname1(dto.getTea_id()));
}
else
{
vt.add("");
}
//vt.add(dto.getSpe_id());
if(dto.getSpe_id()!=null)
{
vt.add(dao.getspename1(dto.getSpe_id()));
}
else
{
vt.add("");
}
dtm.addRow(vt);
}
}
}
/**
* 进行给定班级号的查询，输出它所有的属性
* @param claid
* @param dtm
* @param page
*/
public void select1(String claid,DefaultTableModel dtm, int page)
{
List list=dao.select2(claid);
Iterator it=list.iterator();
// for(int i=0;i<(page-1)*5;i++){
//it.next();}
while(it.hasNext())
{
Vector vt=new Vector();
dto=(ClaDTO)it.next();
vt.add(dto.getCla_id());
vt.add(dto.getTea_id());
if(dto.getTea_id()!=null)
{
vt.add(dao.getteaname1(dto.getTea_id()));
}
else
{
vt.add("");
}
//vt.add(dto.getSpe_id());
if(dto.getSpe_id()!=null)
{
vt.add(dao.getspename1(dto.getSpe_id()));
}
else
{
vt.add("");
}
dtm.addRow(vt);
}
}
/**
* 进行取出数据库中所有班级id的操作
* @param dtm
*/
public void getclaid(DefaultComboBoxModel dtm)
{
List list=dao.select();
Iterator it=list.iterator();
while(it.hasNext())
{
Vector vt=new Vector();
dto=(ClaDTO)it.next();
vt.add(dto.getCla_id());
dtm.insertElementAt(dto.getCla_id(),0);
}
}
/**
* 删除的记录的交互方法
* @param claid
*/
public void delete(String claid)
{
dao.delete(claid);
}
/**
* 取出添加Frame中的所有数据
* @param caf
*/
public void addclass(ClaAddFrame caf)
{
String s=null;
s=dao.getspeid1(caf.speidComboBox1.getSelectedItem().toString());
dto.setCla_id(caf.claidTextField1.getText().trim());
if(caf.teaidComboBox1.getSelectedItem()==null)
{
//dto.setTea_id("");
}
else
{
dto.setTea_id(caf.teaidComboBox1.getSelectedItem().toString());
}
dto.setSpe_id(s);
dao.insert(dto);
}
/**
* 将当前行行的所有属性加入到修改界面中相应的位置
* @param cuf
*/
public void addclass1(ClaUpdateFrame cuf)
{
dto.setCla_id(cuf.claidLabel1.getText());
dto.setTea_id(cuf.teaidComboBox1.getSelectedItem().toString());
dto.setSpe_id(cuf.speidComboBox1.getSelectedItem().toString());
dao.update(dto);
}
/**
* 取出所有的教师的编号
* @param dtm
*/
public void getTeaid(DefaultComboBoxModel dtm)
{
List list=dao.getteaid();
Iterator it=list.iterator();
while(it.hasNext())
{
Vector vt=new Vector();
dto=(ClaDTO)it.next();
vt.add(dto.getTea_id().toString());
dtm.insertElementAt(dto.getTea_id().toString(), 0);
}
}
/**
* 取出所有专业的编号
* @param dtm
*/
public void getSeaid(DefaultComboBoxModel dtm)
{
List list=dao.getspeid();
Iterator it=list.iterator();
while(it.hasNext())
{
Vector vt=new Vector();
dto=(ClaDTO)it.next();
vt.add(dto.getSpe_id().toString());
dtm.insertElementAt(dto.getSpe_id().toString(), 0);
}
}
/**
* 取出所有专业的名称
* @param dtm
*/
public void getspename(DefaultComboBoxModel dtm)
{
List list=dao.getspename();
Iterator it=list.iterator();
while(it.hasNext())
{
Vector vt=new Vector();
dto=(ClaDTO)it.next();
vt.add(dto.getSpe_name());
dtm.insertElementAt(dto.getSpe_name(), 0);
}
}
/**
* 将主界面中选择的行的所有属性放到修改界面中相应的位置
* @param claid
* @param cuf
*/
public void setValue(String claid,ClaUpdateFrame cuf)
{
List list=dao.select1(claid);
Iterator it=list.iterator();
while (it.hasNext())
{
dto=(ClaDTO)it.next();
cuf.claidLabel1.setText(dto.getCla_id());
cuf.teaidComboBox1.setSelectedItem(dto.getTea_id());
cuf.speidComboBox1.setSelectedItem(dto.getSpe_id());
}
}
/**
* 比较专业名是否有重
* @param s
* @return
*/
public boolean compare(String s)
{
List list=dao.getspename();
Iterator it=list.iterator();
while(it.hasNext())
{
dto=(ClaDTO)it.next();
if(s.equals(dto.getSpe_name()))
{
break;
}
}
if(it.hasNext()==false)
{
return false;
}
else
{
return true;
}
}
/**
* 进行班级和出勤表的综合查询
* @param claid
* @param date
* @param sta
* @param dtm
* @param page
*/
public void selectcladuty(String claid,String date,String sta,DefaultTableModel dtm,int page)
{
List list=dao.selectcladuty(claid,date,sta);
Iterator it=list.iterator();
if(list.isEmpty())
{
for(int i=1;i<6;i++)
{
Vector vt=new Vector();
vt.add("");
vt.add("");
vt.add("");
vt.add("");
dtm.addRow(vt);
}
}
else
{
for(int i=0;i<(page-1)*5;i++)
{
it.next();
}
while (it.hasNext())
{
Vector vt=new Vector();
dto1=(DutyDTO)it.next();
vt.add(dto1.getStu_id());
vt.add(dto1.getStu_name());
vt.add(dto1.getDut_date());
vt.add(dto1.getDut_sta());
dtm.addRow(vt);
}
}
}
/**
* 进行班级出勤综合查询的分页的计算
* @param claid
* @param date
* @param sta
* @return
*/
public int getpage(String claid,String date, String sta)
{
List list=dao.selectcladuty(claid,date,sta);
Iterator it=list.iterator();
int page=1;
int count=0;
if(list.isEmpty())
{
page=1;
}
else
{
while (it.hasNext())
{
it.next();
count++;
}
if(count%5==0)
{
page=count/5;
}
else
page=count/5+1;
}
return page;
}
/**
* 取出出勤的时间
* @param claid
* @param date
* @param sta
* @return
*/
public int[] getnumber(String claid,String date, String sta)
{
List list=dao.selectcladuty(claid,date,sta);
Iterator it=list.iterator();
int num1=0;
int num2=0;
int num3=0;
int num4=0;
int a[]={0,0,0,0};
while(it.hasNext())
{
dto1=(DutyDTO)it.next();
if(dto1.getDut_sta().equals("正常"))
{
num1++;
}
if(dto1.getDut_sta().equals("迟到"))
{
num2++;
}
if(dto1.getDut_sta().equals("旷课"))
{
num3++;
}
if(dto1.getDut_sta().equals("早退"))
{
num4++;
}
}
a[0]=num1;
a[1]=num2;
a[2]=num3;
a[3]=num4;
return a;
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -