java mysql学生管理系统_Java+Mysql+学生管理系统

packagecom.test2;/** 修改学生*/

importjavax.swing.JDialog;import javax.swing.*;import java.awt.*;importjava.awt.event.ActionEvent;importjava.awt.event.ActionListener;importjava.sql.Statement;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.ResultSet;import java.sql.*;public class StuUpDiag extends JDialog implementsActionListener {//定义我需要的swing组件

JLabel jl1,jl2,jl3,jl4,jl5,jl6;

JTextField jf1,jf2,jf3,jf4,jf5,jf6;

JPanel jp1,jp2,jp3;

JButton jb1,jb2;//owner代笔父窗口,title是窗口的名字,modal指定是模式窗口()或者非模式窗口

public StuUpDiag(Frame owner,String title, boolean modal,StuModel sm,introwNum){//调用父类方法

super(owner,title,modal);

jl1= new JLabel("学号");

jl2= new JLabel("名字");

jl3= new JLabel("性别");

jl4= new JLabel("年龄");

jl5= new JLabel("籍贯");

jl6= new JLabel("门派");

jf1= new JTextField(10);jf1.setText((sm.getValueAt(rowNum, 0)).toString());

jf2= new JTextField(10);jf2.setText((String)sm.getValueAt(rowNum, 1));

jf3= new JTextField(10);jf3.setText(sm.getValueAt(rowNum, 2).toString());

jf4= new JTextField(10);jf4.setText((sm.getValueAt(rowNum, 3)).toString());

jf5= new JTextField(10);jf5.setText((String)sm.getValueAt(rowNum, 4));

jf6= new JTextField(10);jf6.setText((String)sm.getValueAt(rowNum, 5));

jb1= new JButton("修改");

jb1.addActionListener(this);

jb2= new JButton("取消");

jp1= newJPanel();

jp2= newJPanel();

jp3= newJPanel();//设置布局

jp1.setLayout(new GridLayout(6,1));

jp2.setLayout(new GridLayout(6,1));

jp3.add(jb1);

jp3.add(jb2);

jp1.add(jl1);

jp1.add(jl2);

jp1.add(jl3);

jp1.add(jl4);

jp1.add(jl5);

jp1.add(jl6);

jp2.add(jf1);

jp2.add(jf2);

jp2.add(jf3);

jp2.add(jf4);

jp2.add(jf5);

jp2.add(jf6);this.add(jp1, BorderLayout.WEST);this.add(jp2, BorderLayout.CENTER);this.add(jp3, BorderLayout.SOUTH);this.setSize(300,200);this.setVisible(true);

}

@Overridepublic voidactionPerformed(ActionEvent e) {//TODO Auto-generated method stub

if(e.getSource() ==jb1){

Connection ct= null;

PreparedStatement pstmt= null;

ResultSet rs= null;try{//1.加载驱动

Class.forName("com.mysql.jdbc.Driver");

System.out.println("加载成功");//2.连接数据库//定义几个常量

String url = "jdbc:mysql://localhost:3306/spdb1";

String user= "root";

String passwd= "lfdy";

ct=DriverManager.getConnection(url,user,passwd);//与编译语句对象

String strsql= "insert into stu values(?,?,?,?,?,?)";

pstmt=ct.prepareStatement(strsql);//给对象赋值

pstmt.setString(1,jf1.getText());

pstmt.setString(2,jf2.getText());

pstmt.setString(3,jf3.getText());

pstmt.setString(4,jf4.getText());

pstmt.setString(5,jf5.getText());

pstmt.setString(6,jf6.getText());

pstmt.executeUpdate();this.dispose();//关闭学生对话框

}catch(Exception arg1){

arg1.printStackTrace();

}finally{try{if(rs!=null){

rs.close();

rs= null;

}if(pstmt != null){

pstmt.close();

pstmt= null;

}if(ct != null){

ct.close();

ct= null;

}

}catch(Exception arg2){

arg2.printStackTrace();

}

}

}

}

}