检验mysql的javaee代码_JavaEE-实验三 Java数据库高级编程

packageview;importjava.awt.BorderLayout;importjava.awt.GridLayout;importjava.awt.event.ActionEvent;importjava.awt.event.ActionListener;importjava.util.ArrayList;importjava.util.List;importjavax.swing.JButton;importjavax.swing.JFrame;importjavax.swing.JLabel;importjavax.swing.JOptionPane;importjavax.swing.JPanel;importjavax.swing.JScrollPane;importjavax.swing.JTable;importjavax.swing.JTextField;importdao.PersonDao;importentity.Person;public class TestFrm extendsJFrame{private static final long serialVersionUID = 1L;

PersonDao pd=newPersonDao();

JPanel jp1=newJPanel();

Object[] Names1= {"编号","姓名","性别","电话","地址","email"};

JTable table1;

TestFrm(){

JLabel label1=new JLabel("编号");

JLabel label2=new JLabel("姓名");

JLabel label3=new JLabel("性别");

JLabel label4=new JLabel("电话");

JLabel label5=new JLabel("地址");

JLabel label6=new JLabel("email");

JTextField jt1=newJTextField();

JTextField jt2=newJTextField();

JTextField jt3=newJTextField();

JTextField jt4=newJTextField();

JTextField jt5=newJTextField();

JTextField jt6=newJTextField();

JButton jb1=new JButton("查询");

JButton jb2=new JButton("增加");

JButton jb3=new JButton("删除");

JButton jb4=new JButton("显示所有");

jp1.setLayout(new GridLayout(4, 4));

jp1.add(label1);

jp1.add(jt1);

jp1.add(label2);

jp1.add(jt2);

jp1.add(label3);

jp1.add(jt3);

jp1.add(label4);

jp1.add(jt4);

jp1.add(label5);

jp1.add(jt5);

jp1.add(label6);

jp1.add(jt6);

jp1.add(jb1);

jp1.add(jb2);

jp1.add(jb3);

jp1.add(jb4);

jb1.addActionListener(newActionListener() {

@Overridepublic voidactionPerformed(ActionEvent e) {

String strsql="";if(!jt1.getText().isEmpty())

strsql+=" and pid="+jt1.getText();if(!jt2.getText().isEmpty())

strsql+=" and name='"+jt2.getText()+"'";if(!jt3.getText().isEmpty())

strsql+=" and sex='"+jt3.getText()+"'";if(!jt4.getText().isEmpty())

strsql+=" and tel='"+jt4.getText()+"'";if(!jt5.getText().isEmpty())

strsql+=" and address='"+jt5.getText()+"'";if(!jt6.getText().isEmpty())

strsql+=" and email='"+jt6.getText()+"'";

List list =pd.quarybyitems(strsql);

reset(list);

}

});

jb2.addActionListener(newActionListener() {

@Overridepublic voidactionPerformed(ActionEvent e) {if(jt1.getText().isEmpty()||jt2.getText().isEmpty()||jt3.getText().isEmpty()||jt4.getText().isEmpty()||jt5.getText().isEmpty()||jt6.getText().isEmpty())

JOptionPane.showMessageDialog(null, "请输入完整！！");else{

String strsql="("+jt1.getText()+",\""+jt2.getText()+"\",\""+jt3.getText()+"\",\""+jt4.getText()+"\",\""+jt5.getText()+"\",\""+jt6.getText()+"\")";if(pd.update(strsql)) {

JOptionPane.showMessageDialog(null, "插入成功");

List list =pd.quaryall();

reset(list);

}else{

JOptionPane.showMessageDialog(null, "插入失败");

}

}

}

});

jb3.addActionListener(newActionListener() {

@Overridepublic voidactionPerformed(ActionEvent e) {int pid= (int)table1.getModel().getValueAt(table1.getSelectedRow(), 0);

pd.deletePersonByID(pid);

List list =pd.quaryall();

reset(list);

}

});

jb4.addActionListener(newActionListener() {

@Overridepublic voidactionPerformed(ActionEvent e) {

List list =pd.quaryall();

reset(list);

}

});

List list =pd.quaryall();

reset(list);

setTitle("我的通讯录");

setBounds(600,400,600,350);

setVisible(true);

setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);

}private void reset(Listlist){

List b=new ArrayList();for(Person p:list) {

Object[] o={p.getPid(),p.getName(),p.getSex(),p.getTel(),p.getAddress(),p.getEmail()};

b.add(o);

}

Object[][] a= (Object[][])b.toArray(newObject[b.size()][]);

table1=newJTable(a,Names1);

getContentPane().removeAll();

add(jp1,BorderLayout.NORTH);

add(newJScrollPane(table1),BorderLayout.CENTER);

validate();

}public static voidmain(String[] args) {newTestFrm();

}

}