java写的水电费管理系统

package View; import java.awt.EventQueue; import javax.swing.JInternalFrame; import javax.swing.JScrollPane; import java.awt.BorderLayout; import javax.swing.JTable; import javax.swing.GroupLayout; import javax.swing.GroupLayout.Alignment; import javax.swing.table.DefaultTableModel; import dao.PersonDAOjdbc; import entity.Person; import util.DBUtil; import util.StringUtil; import javax.swing.JLabel; import javax.swing.JOptionPane; import javax.swing.LayoutStyle.ComponentPlacement; import javax.swing.JTextField; import java.awt.Font; import javax.swing.JButton; import java.awt.event.ActionListener; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.Vector; import java.awt.event.ActionEvent; import java.awt.event.MouseAdapter; import java.awt.event.MouseEvent; public class SearchInterFrm extends JInternalFrame { private JTable table; private JTextField searchnameTxt; private JTextField searchwaterconTxt; private JTextField searcheleTxt; private DBUtil db=new DBUtil(); private PersonDAOjdbc persondao=new PersonDAOjdbc(); private JTextField idTxt; private JTextField nameTxt; private JTextField idenTxt; private JTextField genderTxt; private JTextField ageTxt; private JTextField departTxt; private JTextField waterTxt; private JTextField eleTxt; private JTextField payfeeTxt; private String id1; private String id2; /** * Launch the application. */ public static void main(String[] args) { EventQueue.invokeLater(new Runnable() { public void run() { try { SearchInterFrm frame = new SearchInterFrm(); frame.setVisible(true); } catch (Exception e) { e.printStackTrace(); } } }); } /** * Create the frame. */ public SearchInterFrm() { setIconifiable(true); setClosable(true); setBounds(100, 100, 852, 572); JScrollPane scrollPane = new JScrollPane(); JLabel lblNewLabel = new JLabel("\u59D3\u540D\uFF1A"); lblNewLabel.setFont(new Font("宋体", Font.PLAIN, 15)); searchnameTxt = new JTextField(); searchnameTxt.setColumns(10); JLabel lblNewLabel_1 = new JLabel("\u7528\u6C34\u91CF\uFF1A"); lblNewLabel_1.setFont(new Font("宋体", Font.PLAIN, 15)); searchwaterconTxt = new JTextField(); searchwaterconTxt.setColumns(10); JLabel lblNewLabel_2 = new JLabel("\u7528\u7535\u91CF\uFF1A"); lblNewLabel_2.setFont(new Font("宋体", Font.PLAIN, 15)); searcheleTxt = new JTextField(); searcheleTxt.setColumns(10); JButton btnNewButton = new JButton("\u67E5\u8BE2"); btnNewButton.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { filltablemodle(); resetvalues(); } }); btnNewButton.setFont(new Font("宋体", Font.PLAIN, 15)); JButton btnNewButton_1 = new JButton("\u91CD\u7F6E"); btnNewButton_1.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent eve) { resetvalueactionPerformed(eve); } }); btnNewButton_1.setFont(new Font("宋体", Font.PLAIN, 15)); JButton btnNewButton_2 = new JButton("\u4FEE\u6539"); btnNewButton_2.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { String id=idTxt.getText(); String name=nameTxt.getText(); String iden=idenTxt.getText(); String gender=genderTxt.getText(); Integer a=new Integer(ageTxt.getText()); int age=a.intValue(); String depar=departTxt.getText(); Double b=new Double(waterTxt.getText()); double watercon=b.doubleValue(); Double c=new Double(eleTxt.getText()); double elecon=c.doubleValue(); String payfee=payfeeTxt.getText(); if(StringUtil.isEmpty(id)||StringUtil.isEmpty(name)) { JOptionPane.showMessageDialog(null,"学号或姓名不能为空"); resetvalues(); } Connection con=null; Person p=new Person(id,name,iden,gender,age,depar,watercon,elecon,payfee); id2=idTxt.getText(); try { con=db.getCon(); int n=persondao.update(p,id1); if(id1.equals(id2)) { if(n==1) { JOptionPane.showMessageDialog(null,"记录修改成功"); } else { JOptionPane.showMessageDialog(null,"记录修改失败"); } } else { String sql1="select * from personchart "; try { PreparedStatement pst=con.prepareStatement(sql1); ResultSet rs=pst.executeQuery(); while(rs.next()) { if(rs.getString("id").equals(p.getId())) { n=-1; } } } catch (SQLException e1) { // TODO Auto-generated catch block e1.printStackTrace(); } if(n==1) { JOptionPane.showMessageDialog(null,"记录修改成功"); } else if (n==-1){ JOptionPane.showMessageDialog(null,"输入ID重复 请重新输入"); } else { JOptionPane.showMessageDialog(null,"记录修改失败"); } } } catch (Exception e1) { // TODO Auto-generated catch block e1.printStackTrace(); } resetvalues(); } } ); btnNewButton_2.setFont(new Font("宋体", Font.PLAIN, 15)); JButton btnNewButton_3 = new JButton("\u91CD\u7F6E"); btnNewButton_3.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { resetactionPerformed(e); } }); btnNewButton_3.setFont(new Font("宋体", Font.PLAIN, 15)); JLabel lblNewLabel_3 = new JLabel("\u5B66\u53F7/\u5DE5\u53F7\uFF1A"); JLabel lblNewLabel_4 = new JLabel("\u59D3\u540D\uFF1A"); JLabel lblNewLabel_5 = new JLabel("\u8EAB\u4EFD\uFF1A"); idTxt = new JTextField(); idTxt.setColumns(10); nameTxt = new JTextField(); nameTxt.setColumns(10); idenTxt = new JTextField(); idenTxt.setColumns(10); JLabel lblNewLabel_6 = new JLabel("\u6027\u522B\uFF1A"); JLabel lblNewLabel_7 = new JLabel("\u5E74\u9F84\uFF1A"); JLabel lblNewLabel_8 = new JLabel("\u73ED\u7EA7/\u90E8\u95E8\uFF1A"); JLabel lblNewLabel_9 = new JLabel("\u7528\u6C34\u91CF\uFF1A"); JLabel lblNewLabel_10 = new JLabel("\u7528\u7535\u91CF\uFF1A"); JLabel lblNewLabel_11 = new JLabel("\u662F\u5426\u7F34\u8D39\uFF1A"); genderTxt = new JTextField(); genderTxt.setColumns(10); ageTxt = new JTextField(); ageTxt.setColumns(10); departTxt = new JTextField(); departTxt.setColumns(10); waterTxt = new JTextField(); waterTxt.setColumns(10); eleTxt = new JTextField(); eleTxt.setColumns(10); payfeeTxt = new JTextField(); payfeeTxt.setColumns(10); GroupLayout groupLayout = new GroupLayout(getContentPane()); groupLayout.setHorizontalGroup( groupLayout.createParallelGroup(Alignment.LEADING) .addGroup(groupLayout.createSequentialGroup() .addGroup(groupLayout.createParallelGroup(Alignment.LEADING) .addGroup(groupLayout.createSequentialGroup() .addGap(176) .addComponent(btnNewButton, GroupLayout.PREFERRED_SIZE, 97, GroupLayout.PREFERRED_SIZE) .addGap(189) .addComponent(btnNewButton_1, GroupLayout.PREFERRED_SIZE, 97, GroupLayout.PREFERRED_SIZE)) .addGroup(groupLayout.createSequentialGroup() .addGap(24) .addGroup(groupLayout.createParallelGroup(Alignment.LEADING) .addComponent(scrollPane, GroupLayout.PREFERRED_SIZE, 791, GroupLayout.PREFERRED_SIZE) .addGroup(groupLayout.createSequentialGroup() .addComponent(lblNewLabel, GroupLayout.PREFERRED_SIZE, 79, GroupLayout.PREFERRED_SIZE) .addPreferredGap(ComponentPlacement.RELATED) .addComponent(searchnameTxt, GroupLayout.PREFERRED_SIZE, 114, GroupLayout.PREFERRED_SIZE) .addGap(34) .addComponent(lblNewLabel_1, GroupLayout.PREFERRED_SIZE, 70, GroupLayout.PREFERRED_SIZE) .addGap(4) .addCo