package daoimpl;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;
import Dao.DBUtils;
import Dao.YuangongDao;
import entity.Plan;
import entity.Useryuangong;
import entity.Yuangong;;
public class YuangongDaoimpl implements YuangongDao{
public int add(Yuangong yuangong) {
int code=0;
String sql="insert into yuangong (id,name,bumen,product,plan,wage) values(?,?,?,?,?,?)";
code= DBUtils.update(sql,yuangong.getId(),yuangong.getName(),yuangong.getBumen(),yuangong.getProduct(),yuangong.getPlan(),yuangong.getWage());
return code;
}
@Override
public int add(Useryuangong ut) {
return 0;
}
@Override
public List<Useryuangong> getUserCustomer(Useryuangong ut) {
return null;
}
@Override
public List<Useryuangong> find() {
return null;
}
@Override
public int delete(Yuangong yuangong) {
int code=0;
String sql="delete from yuangong where id=?";
code=DBUtils.update(sql,yuangong.getId());
return code;
}
@Override
public int delete(int teaid) {
return 0;
}
@Override
public List<Yuangong> getByID(int tid) {
String sql="select *from yuangong where id=?";
List<Yuangong> teacherList=new ArrayList<Yuangong>();
List<Map<String,Object>> mapList=DBUtils.query(sql,new Integer(tid));
for (Map<String,Object>map:mapList){
Yuangong t1=new Yuangong();
t1.setId((Integer) (map.get("员工编号")));
t1.setName((String) (map.get("姓名")));
t1.setBumen((String)(map.get("所属部门")));
t1.setProduct((String) (map.get("产品类型")));
t1.setPlan((String)(map.get("任务计划编号")));
t1.setWage((Integer) (map.get("工资")));
teacherList.add(t1);
}
return teacherList;
}
@Override
public List<Yuangong> getAll() {
return null;
}
}
package daoimpl;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;
import Dao.DBUtils;
import Dao.YuangongDao;
import entity.Plan;
import entity.Useryuangong;
import entity.Yuangong;;
public class YuangongDaoimpl implements YuangongDao{
public int add(Yuangong yuangong) {
int code=0;
String sql="insert into yuangong (id,name,bumen,product,plan,wage) values(?,?,?,?,?,?)";
code= DBUtils.update(sql,yuangong.getId(),yuangong.getName(),yuangong.getBumen(),yuangong.getProduct(),yuangong.getPlan(),yuangong.getWage());
return code;
}
@Override
public int add(Useryuangong ut) {
return 0;
}
@Override
public List<Useryuangong> getUserCustomer(Useryuangong ut) {
return null;
}
@Override
public List<Useryuangong> find() {
return null;
}
@Override
public int delete(Yuangong yuangong) {
int code=0;
String sql="delete from yuangong where id=?";
code=DBUtils.update(sql,yuangong.getId());
return code;
}
@Override
public int delete(int teaid) {
return 0;
}
@Override
public List<Yuangong> getByID(int tid) {
String sql="select *from yuangong where id=?";
List<Yuangong> teacherList=new ArrayList<Yuangong>();
List<Map<String,Object>> mapList=DBUtils.query(sql,new Integer(tid));
for (Map<String,Object>map:mapList){
Yuangong t1=new Yuangong();
t1.setId((Integer) (map.get("员工编号")));
t1.setName((String) (map.get("姓名")));
t1.setBumen((String)(map.get("所属部门")));
t1.setProduct((String) (map.get("产品类型")));
t1.setPlan((String)(map.get("任务计划编号")));
t1.setWage((Integer) (map.get("工资")));
teacherList.add(t1);
}
return teacherList;
}
@Override
public List<Yuangong> getAll() {
return null;
}
}
package gui;
import Dao.YuangongDao;
import daoimpl.YuangongDaoimpl;
import entity.Yuangong;
import javax.swing.*;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.*;
import java.util.List;
public class EduTeacherInformation extends JFrame implements ActionListener {
JLabel jl = new JLabel("<html><body><div style='color:#36648B;font-size:25px;font-family:黑体;'>个人信息查询</div></body><ml>");
JMenuBar jmb=new JMenuBar();
JMenu jMenu=new JMenu("功能");
JMenu helpMenu=new JMenu("帮助");
JMenuItem exitItem=new JMenuItem("退出");
JRadioButtonMenuItem jcb=new JRadioButtonMenuItem("信息查询");
JLabel jId=new JLabel("员工编号：");
JTextField jtfId=new JTextField("",100);
public EduTeacherInformation(String title) {
// TODO Auto-generated constructor stub
super(title);
Container container=this.getContentPane();;
container.setLayout(null);
container.add(jl);
container.add(jId);
container.add(jtfId);
this.setJMenuBar(jmb);
jmb.add(jMenu);
jmb.add(helpMenu);
jMenu.add(exitItem);
ButtonGroup bg=new ButtonGroup();
bg.add(jcb);
jMenu.add(jcb);
jMenu.addActionListener(this);
jcb.addActionListener(this);
exitItem.addActionListener(this);
jtfId.addActionListener(this);
jId.setBounds(10, 20, 60, 40);
jtfId.setBounds(80, 20, 100, 40);
jl.setBounds(260,20,300,200);
this.setSize(700, 520);
this.setVisible(true);
this.setDefaultCloseOperation(WindowConstants.EXIT_ON_CLOSE);
}
Connection conn;
ResultSet rs;
Statement statement;
//连接数据库
public void connDB() {
try {
Class.forName("com.mysql.cj.jdbc.Driver");
} catch (ClassNotFoundException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
String url="jdbc:mysql://localhost:3306/crm?useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT";
try {
conn = DriverManager.getConnection(url,"root","20020808zhl");
}catch(Exception e) {
e.printStackTrace();
}
}
//关闭数据库
public void closeDB() {
try {
rs.close();
statement.close();
conn.close();
}catch(Exception e) {
e.printStackTrace();
}
}
@Override
public void actionPerformed(ActionEvent e) {
// TODO Auto-generated method stub
this.connDB();
YuangongDao yuangongDao=new YuangongDaoimpl();
System.out.println(e.getActionCommand());
if ("退出".equals(e.getActionCommand())) {
this.dispose();
new EduTeaMenu("");
}else if("信息查询".equals(e.getActionCommand())){
List<Yuangong>teacherlist=null;
teacherlist=yuangongDao.getByID(Integer.parseInt(jtfId.getText()));
try {
new TeacherTable(teacherlist);
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
}
}
public static void main(String[] args) {
new EduTeacherInformation("员工信息界面");
}
}
你要知道具体哪一行报错，报错信息发出来。
Exception in thread "AWT-EventQueue-0"线程异常的问题。
if ("退出".equals(e.getActionCommand())) {
改为
if (e.getSource()==exitItem)) {