韩顺平学生管理系统代码_Java

package com.test1; import java.awt.*; import java.awt.event.*; import java.sql.*; import javax.swing.*; public class StuUpdDialog extends JDialog implements ActionListener { //定义我需要的组件 JLabel jl1,jl2,jl3,jl4,jl5,jl6; JButton jb1,jb2; JTextField jtf1,jtf2,jtf3,jtf4,jtf5,jtf6; JPanel jp1,jp2,jp3; //owner的父窗口 //窗口名字 //model只模态还是非模态 public StuUpdDialog(Frame owner,String title, boolean modal,StuModel sm,int rowNums) { super(owner,title,modal); jl1=new JLabel("学号"); jl2=new JLabel("名字"); jl3=new JLabel("性别"); jl4=new JLabel("年龄"); jl5=new JLabel("籍贯"); jl6=new JLabel("系别"); jtf1=new JTextField(); //初始化数据 jtf1.setText((String)sm.getValueAt(rowNums, 0)); //jtf1不能修改 jtf1.setEditable(false); jtf2=new JTextField(); jtf2.setText((String)sm.getValueAt(rowNums, 1)); jtf3=new JTextField(); jtf3.setText((String)sm.getValueAt(rowNums, 2)); jtf4=new JTextField(); jtf4.setText(sm.getValueAt(rowNums, 3).toString()); jtf5=new JTextField(); jtf5.setText((String)sm.getValueAt(rowNums, 4)); jtf6=new JTextField(); jtf6.setText((String)sm.getValueAt(rowNums, 5)); jb1=new JButton("修改"); jb2=new JButton("取消"); jp1=new JPanel(); jp2=new JPanel(); jp3=new JPanel(); //设置布局 jp1.setLayout(new GridLayout(6,1)); jp2.setLayout(new GridLayout(6,1)); //添加组件 jp1.add(jl1); jp1.add(jl2); jp1.add(jl3); jp1.add(jl4); jp1.add(jl5); jp1.add(jl6); jp2.add(jtf1); jp2.add(jtf2); jp2.add(jtf3); jp2.add(jtf4); jp2.add(jtf5); jp2.add(jtf6); jp3.add(jb1); jp3.add(jb2); this.add(jp1,BorderLayout.WEST); this.add(jp2,BorderLayout.CENTER); this.add(jp3,BorderLayout.SOUTH); jb1.addActionListener(this); this.setSize(300,200); this.setVisible(true); } @Override public void actionPerformed(ActionEvent e) { // TODO Auto-generated method stub if(e.getSource()==jb1) { //连接数据库 Connection conn=null; Statement stmt=null; ResultSet rs=null; PreparedStatement pstmt=null; //连接数据库 判断用户是否合法 try { //加载驱动 Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); //创建对象 String url="jdbc:microsoft:sqlserver://127.0.0.1:1433;databaseName=spdb1"; conn=DriverManager.getConnection(url,"sa",""); //与编译语句对象 String strsql="update stu set stuName=?,stuSex=?,stuAge=?,stuJg=?,stuDept=? where stuId=?"; pstmt=conn.prepareStatement(strsql); //给参数价值 pstmt.setString(1, jtf2.getText()); pstmt.setString(2, jtf3.getText()); pstmt.setString(3, jtf4.getText()); pstmt.setString(4, jtf5.getText()); pstmt.setString(5, jtf6.getText()); pstmt.setString(6, jtf1.getText()); //执行操作 pstmt.executeUpdate(); //关闭对话框 this.dispose(); } catch (ClassNotFoundException e2) { e2.printStackTrace(); // TODO: handle exception }catch(SQLException ex){ ex.printStackTrace(); } finally{ try { if(rs!=null) rs.close(); if(stmt!=null) stmt.close(); if(conn!=null) conn.close(); } catch (Exception ex) { ex.printStackTrace(); // TODO: handle exception } } } } }