数据库驾校

import java.awt.BorderLayout; import java.awt.*; import java.awt.event.ActionEvent; import java.awt.event.MouseAdapter; import java.awt.event.MouseEvent; import javax.swing.*; import javax.swing.border.EmptyBorder; import java.sql.*; import java.text.ParseException; import java.text.SimpleDateFormat; import java.awt.event.ActionListener; public class xiugai extends JFrame { private JPanel contentPane; String number1[]=new String[100]; int i; JList list; private JTextField no; String no1; String empName; String empsex; Date empbirthday; String empphone; String schoolNo; String emptype; String emptitle; Date da; private JTextField empname; private JTextField birth; private JTextField phone; private JTextField schoolno; private JTextField type; private JTextField title; String url = "jdbc:sqlserver://127.0.0.1:1433;databaseName=驾校;" + "user=dkk;password=dingkangkang"; Connection con = null; Statement stmt = null; public xiugai() { super("修改员工信息"); getContentPane().setLayout(null); setBounds(100, 100, 475, 457); contentPane = new JPanel(); contentPane.setBorder(new EmptyBorder(5, 5, 5, 5)); setContentPane(contentPane); contentPane.setLayout(null); JLabel lblNewLabel = new JLabel("\u5728\u5DE6\u9762\u5217\u8868\u53CC\u51FB\u8981\u4FEE\u6539\u7684\u5458\u5DE5\u5DE5\u53F7"); lblNewLabel.setBackground(Color.BLUE); lblNewLabel.setBounds(23, 7, 414, 34); contentPane.add(lblNewLabel); JLabel label = new JLabel("\u5DE5\u53F7:"); label.setBounds(186, 60, 36, 15); contentPane.add(label); no = new JTextField(); no.setEditable(false); no.setBounds(242, 51, 148, 34); contentPane.add(no); no.setColumns(10); JRadioButton male = new JRadioButton("\u7537"); male.setBounds(252, 130, 54, 23); contentPane.add(male); JRadioButton fmale = new JRadioButton("\u5973"); fmale.setBounds(323, 130, 54, 23); contentPane.add(fmale); ButtonGroup sexGroup=new ButtonGroup(); sexGroup.add(male); sexGroup.add(fmale); JLabel label_2 = new JLabel("\u59D3\u540D\uFF1A"); label_2.setBounds(186, 97, 36, 15); contentPane.add(label_2); empname = new JTextField(); empname.setBounds(242, 95, 148, 34); contentPane.add(empname); empname.setColumns(10); birth = new JTextField(); birth.setColumns(10); birth.setBounds(242, 159, 148, 34); contentPane.add(birth); JLabel label_3 = new JLabel("\u51FA\u751F\u65E5\u671F\uFF1A"); label_3.setBounds(180, 168, 71, 15); contentPane.add(label_3); JLabel label_4 = new JLabel("\u624B\u673A\u53F7\uFF1A"); label_4.setBounds(180, 203, 71, 15); contentPane.add(label_4); phone = new JTextField(); phone.setColumns(10); phone.setBounds(242, 194, 148, 34); contentPane.add(phone); schoolno = new JTextField(); schoolno.setColumns(10); schoolno.setBounds(242, 238, 148, 34); contentPane.add(schoolno); JLabel label_5 = new JLabel("\u5206\u6821\u7F16\u53F7\uFF1A"); label_5.setBounds(180, 246, 71, 15); contentPane.add(label_5); JLabel label_6 = new JLabel("\u5458\u5DE5\u7C7B\u522B\uFF1A"); label_6.setBounds(180, 290, 71, 15); contentPane.add(label_6); type = new JTextField(); type.setColumns(10); type.setBounds(242, 281, 148, 34); contentPane.add(type); JLabel label_7 = new JLabel("\u5458\u5DE5\u804C\u79F0\uFF1A"); label_7.setBounds(180, 331, 71, 15); contentPane.add(label_7); title = new JTextField(); title.setColumns(10); title.setBounds(242, 328, 148, 34); contentPane.add(title); try{ Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); }catch(ClassNotFoundException e){ e.printStackTrace(); } try{ Connection conn=DriverManager.getConnection(url); Statement stmt=conn.createStatement(); String sql="SELECT * FROM Employees"; ResultSet rs=stmt.executeQuery(sql); number1[0]="......员工工号......"; i=1; while(rs.next()){ number1[i]=rs.getString("empno"); i++; } list=new JList(number1); list.addMouseListener(new MouseAdapter() { public void mouseClicked(MouseEvent e) { if(e.getClickCount()==2) { String s1=(String)list.getSelectedValue(); try{ Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); }catch(ClassNotFoundException e1){ e1.printStackTrace(); } try{ Connection conn=DriverManager.getConnection(url); PreparedStatement pstmt = conn.prepareStatement("{call dbo.select1(?)}"); pstmt.setString(1,s1); ResultSet rs=pstmt.executeQuery(); while(rs.next()){ no1=rs.getString("empno"); no.setText(no1); empName=rs.getString("empname"); empname.setText(empName); empsex=rs.getString("empsex"); if(empsex.equals("男 ")) { male.setSelected(true); } else { fmale.setSelected(true); } empbirthday=rs.getDate("empbirthday"); SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd"); String str=sdf.format(empbirthday); birth.setText(str); empphone=rs.getString("empphone"); phone.setText(empphone); schoolNo=rs.getString("schoolno"); schoolno.setText(schoolNo); emptype=rs.getString("emptype"); type.setText(emptype); emptitle=rs.getString("title"); title.setText(emptitle); } }catch(SQLException e1){ e1.printStackTrace(); } } } }); rs.close(); stmt.close(); conn.close(); }catch(SQLException e){ e.printStackTrace(); } list.setBounds(10, 39, 119, 493); contentPane.add(list); JLabel label_1 = new JLabel("\u6027\u522B\uFF1A"); label_1.setBounds(186, 132, 65, 19); contentPane.add(label_1); JButton xiugai = new JButton("\u4FEE\u6539"); xiugai.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { try{ Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); }catch(ClassNotFoundException e1){ e1.printStackTrace(); } try{ Connection conn=DriverManager.getConnection(url); PreparedStatement pstmt = conn.prepareStatement("{call dbo.update1(?,?,?,?,?,?,?,?)}"); pstmt.setString(1,no.getText()); pstmt.setString(2,empname.getText()); if(male.isSelected()) { empsex="男"; }else empsex="女"; pstmt.setString(3,empsex); String birthday=birth.getText(); SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd"); try { da= new Date(sdf.parse(birthday).getTime()); } catch (ParseException e2) { // TODO Auto-generated catch block e2.printStackTrace(); } pstmt.setDate(4,da); pstmt.setString(5,phone.getText()); pstmt.setString(6,schoolno.getText()); pstmt.setString(7,type.getText()); emptitle=title.getText(); if("".equals(emptitle)) emptitle=null; ps