中学java通讯录.docx

1、中学java通讯录中学java通讯录java通讯录import java.awt.*; import java.awt.event.*; import javax.swing.*; import java.sql.*; class MyJFrame extends JFrame implements ActionListener JLabel lid=new JLabel(编号),lname=new JLabel(姓名),lsex=new JLabel(性别),lah=new JLabel(爱好),lphone=new JLabel(联系电话), laddress=new JLabel(地址)

2、,lbz=new JLabel(备注);JLabel aa=new JLabel(编号 姓名); JTextField tid=new JTextField(10),tname=new JTextField(10), tphone=new JTextField(15), taddress=new JTextField(30); JButton jadd=new JButton(添加); JButton jupd=new JButton(修改); JButton jdel=new JButton(删除); JButton jcls=new JButton(清空); Choice tsex,tah

3、,tbz;JPanel p1,p2;List ls1; JMenuBar mb; MyJFrame(String title) super(title); /设置窗体的标题; mb= new JMenuBar(); /框架f上添加菜单JMenu m1=new JMenu(查询);JMenu m2=new JMenu(退出); JMenuItem open=new JMenuItem(查看全部);JMenuItem close=new JMenuItem(查询个人);JMenuItem exit=new JMenuItem(退出); m1.add(open); / 将菜单项加入到菜单m1 中m1

4、.add(close); m2.add(exit);mb.add(m1);mb.add(m2); setJMenuBar(mb); tsex=new Choice();tah=new Choice();tbz=new Choice();tsex.addItem(男);tsex.addItem(女); tah.addItem(上网);tah.addItem(运动);tah.addItem(逛街);tah.addItem(游戏); tbz.addItem(朋友);tbz.addItem(家人);tbz.addItem(同事);tbz.addItem(同学); this.setSize(650,40

5、0); /可以根据实际界面的大小改变;this.setLocation(400,280); /设置窗体在桌面大位置;Container con=getContentPane ( ); /返回此窗体的 contentPane 对象。 con.setBackground (Color.lightGray); /根据实际需要，设置窗体的背景色; con.setLayout(new GridLayout(1,2); ls1 = new List(); /con.add(ls1); p2 = new JPanel(); p2.setLayout(new GridLayout(0,1); p2.add(l

6、s1);p2.setBorder(BorderFactory.createTitledBorder(编号 姓名 性别 电话 地址 爱好 备注);con.add(p2); p1 = new JPanel(); p1.setLayout(new GridLayout(9,2); p1.setBorder(BorderFactory.createTitledBorder(录入联系人信息); con.add(p1); p1.add(lid);p1.add(tid); p1.add(lname);p1.add(tname); p1.add(lsex);p1.add(tsex); p1.add(lah);

7、p1.add(tah); p1.add(lphone);p1.add(tphone); p1.add(laddress);p1.add(taddress); p1.add(lbz);p1.add(tbz); p1.add(jadd);p1.add(jdel); p1.add(jcls); p1.add(jupd); jadd.addActionListener(this); jcls.addActionListener(this); jdel.addActionListener(this); jupd.addActionListener(this); open.addActionListene

8、r(this); close.addActionListener(this); exit.addActionListener(this); setDefaultCloseOperation(3); /设置窗体点击关闭按钮是要执行的操作; setVisible(true); /设置窗体显示出来; try Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); catch (Exception e2) public void actionPerformed(ActionEvent e) String number=tid.getText(); String nam

9、e=tname.getText(); String sex=tsex.getSelectedItem(); String bz=tbz.getSelectedItem(); String phone=tphone.getText(); String address=taddress.getText(); String ah=tah.getSelectedItem(); try Connection con=DriverManager.getConnection(jdbc:odbc:student);Statement sta=con.createStatement(); if(e.getSou

10、rce()=jadd)/添加 String sql=insert into student(学号,姓名,性别,爱好,联系电话,家庭地址,备注) values (+number+,+name+,+sex+,+ah+,+phone+,+address+,+bz+); if (number.length() = 0 | name.length() = 0|ah.length() = 0 | bz.length() = 0 | sex.length() = 0 | phone.length() = 0 | address.length() = 0) JOptionPane.showMessageDia

11、log(null,输入信息不能为空); else String sqlString = select count(*) from student where 学号 = +number; int rowCount = 0; try ResultSet rs = sta.executeQuery(sqlString);if (rs.next() System.out.println(rowCount = rs.getInt(1); if (rowCount 0) JOptionPane.showMessageDialog(null, Sorry!这个编号的学生已经存在，请检查是否输入有误); el

12、se sta.executeUpdate(sql); JOptionPane.showMessageDialog(null, 添加成功); catch(Exception e3) System.out.print(hello world); if(e.getActionCommand()=查看全部)/查询全部 ls1.clear(); ResultSet rs; String sql0String = select count(*) from student; int rc = 0; rs = sta.executeQuery(sql0String); if (rs.next() System

13、.out.println(rc = rs.getInt(1); if (rc=0) JOptionPane.showMessageDialog(null, 对不起，通讯录此时无任何联系人); rs=sta.executeQuery(select * from student);while(rs.next() String str; str=rs.getString(学号)+ +rs.getString(姓名)+ +rs.getString(性别)+ +rs.getString(联系电话)+ +rs.getString(家庭地址)+ +rs.getString(爱好)+ +rs.getStrin

14、g(备注); ls1.add(str); if(e.getActionCommand()=查询个人)/查询个人 ls1.clear(); ResultSet rs; String xh=JOptionPane.showInputDialog(this,请输入要查询的学号,查询,JOptionPane.OK_CANCEL_OPTION); if(xh.length() = 0) JOptionPane.showMessageDialog(null, 请输入条件); try String sql0String = select count(*) from student where 学号 = +x

15、h; int rc = 0; rs = sta.executeQuery(sql0String);if (rs.next() System.out.println(rc = rs.getInt(1); if (rc=0) JOptionPane.showMessageDialog(null, Sorry!这个编号的人不存在); else rs=sta.executeQuery(select * from student WHERE 学号=+xh); if(rs.next() String str; str=学号:n+rs.getString(学号)+ +rs.getString(姓名)+ +r

16、s.getString(性别)+ +rs.getString(联系电话)+ +rs.getString(家庭地址)+ +rs.getString(爱好)+ +rs.getString(备注);ls1.add(str); catch (Exception e3) if(e.getSource()=jupd)/修改 number = tid.getText(); ResultSet rs; if (number.length()= 0) JOptionPane.showMessageDialog(null, Sorry!你没有输入学号); String sql0String = select co

17、unt(*) from student where 学号 = +number; int rc = 0; rs = sta.executeQuery(sql0String); if (rs.next() System.out.println(rc = rs.getInt(1); if (rc=0) JOptionPane.showMessageDialog(null, Sorry!这个编号的人不存在); String sqlString = DELETE FROM student WHERE 学号=+number; sta.executeUpdate(sqlString);/执行语句，结果放在r

18、s String sql=insert into student(学号,姓名,性别,爱好,联系电话,家庭地址,备注) values (+number+,+name+,+sex+,+ah+,+phone+,+address+,+bz+); sta.executeUpdate(sql); JOptionPane.showMessageDialog(null, 修改成功); if(e.getSource()=jcls)/清除 ls1.clear(); String sqlString = DELETE FROM student;try sta.executeUpdate(sqlString); JO

19、ptionPane.showMessageDialog(null, 清除成功); catch (SQLException e1) e1.printStackTrace(); if (e.getSource()= jdel) / 删除 String xh=JOptionPane.showInputDialog(this,请输入要修改的学号,查询,JOptionPane.OK_CANCEL_OPTION); if(xh.length() = 0) JOptionPane.showMessageDialog(null, 请输入条件); try String sql0String = select c

20、ount(*) from student where 学号 = +xh; int rc = 0; ResultSet rs = sta.executeQuery(sql0String); if (rs.next() System.out.println(rc = rs.getInt(1); if (rc =0) JOptionPane.showMessageDialog(null, Sorry!这个编号的学生不存在，请检查是否输入有误); else sta.executeUpdate(DELETE FROM student WHERE 学号=+xh); sta.close(); con.clo

21、se(); JOptionPane.showMessageDialog(this,删除成功,成功,JOptionPane.PLAIN_MESSAGE); catch(SQLException e2) System.out.println(e2); if(e.getActionCommand()=退出) System.exit(0); catch (Exception e1) tid.setText(); tname.setText(); tphone.setText(); taddress.setText(); public class Test4 public static void main(String args) new MyJFrame(非常非常非常简单的通讯录); /创建窗体对象;