1、Xsxxgl.java
import java.awt.*;
import java.awt.event.*;import java.sql.*;
import java.util.*;
import javax.swing.*;
public class Xsxxgl extends JFrame implements ActionListener{
JPanel mb1;
JButton an1,an2,an3,an4;
JTable bg1;
JScrollPane gd1;
Vector ziduan,jilu;
PreparedStatement ps=null;
Connection ct=null;
ResultSet rs=null;
public Xsxxgl(){
an1=new JButton("查询");
an1.addActionListener(this);
an1.setActionCommand("chaxun");
an2=new JButton("增加");
an2.addActionListener(this);
an2.setActionCommand("zhengjia");
an3=new JButton("修改");
an3.addActionListener(this);
an3.setActionCommand("xiugai");
an4=new JButton("删除");
an4.addActionListener(this);
an4.setActionCommand("shanchu");
mb1=new JPanel();
mb1.setLayout(new GridLayout(4,1));
mb1.add(an1);
mb1.add(an2);
mb1.add(an3);
mb1.add(an4);
ziduan=new Vector();
ziduan.add("学号");
ziduan.add("姓名");
ziduan.add("性别");
ziduan.add("年龄");
jilu=new Vector();
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
ct=DriverManager.getConnection("jdbc:odbc:sql server");
ps=ct.prepareStatement("select * from Table_3");
rs=ps.executeQuery();
while(rs.next()){
Vector hang=new Vector();
hang.add(rs.getString(1));
hang.add(rs.getString(2));
hang.add(rs.getString(3));
hang.add(rs.getString(4));
jilu.add(hang);
}
}catch(Exception e){}
finally{
try{
if(rs!=null)
{
rs.close();
}
if(ps!=null)
{
ps.close();
}
if(ct!=null)
{
ct.close();
}
}catch(Exception e2){
}
}
bg1=new JTable(jilu,ziduan);
gd1=new JScrollPane(bg1);
this.add(gd1);
this.add(mb1,BorderLayout.WEST);
this.setTitle("学生管理系统");
this.setSize(500,400);
this.setLocation(201,181);
this.setResizable(false);
this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
this.setVisible(true);
}
public void actionPerformed(ActionEvent e){
if(e.getActionCommand().equals("chaxun")){
chaxun cx=new chaxun(this,"查询学生信息",true);
xsxx xsxx2=new xsxx();
bg1.setModel(xsxx2);
}
else if(e.getActionCommand().equals("zhengjia")){
zhengjia tj=new zhengjia(this,"添加学生信息",true);
xsxx xsxx2=new xsxx();
bg1.setModel(xsxx2);
}
else if(e.getActionCommand().equals("xiugai")){
int ii=this.bg1.getSelectedRow();
if(ii==-1){
JOptionPane.showMessageDialog(this,"请选中要修改的行");
return;
}
xsxx xsxx2=new xsxx();
new xiugai(this,"修改学生信息",true,xsxx2,ii);
bg1.setModel(xsxx2);
}
else if(e.getActionCommand().equals("shanchu")){
xsxx xsxx2=new xsxx();
int ii=this.bg1.getSelectedRow();
if(ii==-1){
JOptionPane.showMessageDialog(this,"请选中要删除的行");
return;
}
String st=(String)xsxx2.getValueAt(ii,0);
PreparedStatement ps=null;
Connection ct=null;
ResultSet rs=null;
Statement sm=null;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
ct=DriverManager.getConnection("jdbc:odbc:sql server");
ps=ct.prepareStatement("delete from Table_3 where xuehao=?");
ps.setString(1, st);
ps.executeUpdate();
}catch(Exception e2){}
finally
{
try {
if(rs!=null)
{
rs.close();
}
if(ps!=null)
{
ps.close();
}
if(ct!=null)
{
ct.close();
}
} catch (Exception e3){}
}
bg1.setModel(xsxx2);
}
}
public static void main(String args[]){
Xsxxgl xs=new Xsxxgl();
}
}
![](https://i-blog.csdnimg.cn/blog_migrate/cf5e49c72d5d444c19d341dc7bdf6f20.png)