使用Java Swing界面实现数据库基本操作-Java频道-中国IT实验室

import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.*;
import java.awt.*;
import javax.swing.*;

public class data extends JFrame implements ActionListener{
    JButton add,select,del,update;
    JTable table;
    Object body[][]=new Object[50][4];
    String title[]={"编号","姓名","分数","级别"};
    Connection conn;
    Statement stat;
    ResultSet rs;
    JTabbedPane tp;
    public data() {
        super("数据库操作");
        this.setSize(400,300);
        this.setLocation(300,200);
        this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
        JPanel ps=new JPanel();
        add=new JButton("添加");
        select=new JButton("显示");
        update=new JButton("更改");
        del=new JButton("删除");
        add.addActionListener(this);
        select.addActionListener(this);
        update.addActionListener(this);
        del.addActionListener(this);
        ps.add(add);ps.add(select);ps.add(update);ps.add(del);
        table=new JTable(body,title);
        tp=new JTabbedPane();
        tp.add("bankAccount表",new JScrollPane(table));
        this.getContentPane().add(tp,"Center");
        this.getContentPane().add(ps,"South");
        this.setVisible(true);
        this.connection();


    }
    public void connection(){
    try {
        Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
        String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=dxaw";
        conn=DriverManager.getConnection(url,"dxaw","123");
        stat = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
    } catch (Exception ex) {
    }
    }
    public static void main(String[] args) {
        data data = new data();
    }

    public void actionPerformed(ActionEvent e) {
        if(e.getSource()==add)
        {add();}
        if(e.getSource()==select)
        {select();}
        if(e.getSource()==update)
        {update();}
        if(e.getSource()==del)
        {del();}
    }


    public void del() {
    try {

    int row=table.getSelectedRow();
    stat.executeUpdate("delete bankAccount where accountID='"+body[row][0]+"'");
    JOptionPane.showMessageDialog(null,"数据已成功删除");
       this.select();
    } catch (SQLException ex) {
        }
    }

    public void update() {
    try {
            int row=table.getSelectedRow();

            JTextField t[]=new JTextField[6];
               t[0]=new JTextField("输入姓名:");
               t[0].setEditable(false);
               t[1]=new JTextField();
               t[2]=new JTextField("输入分数:");
               t[2].setEditable(false);
               t[3]=new JTextField();
               t[4]=new JTextField("输入级别:");
               t[4].setEditable(false);
               t[5]=new JTextField();
               String but[]={"确定","取消"};
               int go=JOptionPane.showOptionDialog(
null,t,"插入信息",JOptionPane.YES_OPTION,
JOptionPane.INFORMATION_MESSAGE,null,but,but[0]);
   if(go==0){
   String ownerName=new String(t[1].getText().getBytes("ISO-8859-1"),
"GBK");
   String accountValue=t[3].getText();
   int accountLevel=Integer.parseInt(t[5].getText());
   stat.executeUpdate("update bankAccount set ownerName='"+ownerName+"',
   accountValue='"+accountValue+"',accountLevel='"+accountLevel+"' 
   where accountID='"+body[row][0]+"'");
   JOptionPane.showMessageDialog(null,"修改数据成功");
    this.select();
    }

     } catch (Exception ex) {
    }
    }

    public void select() {
        try {
            for(int x=0;x

--------------------next---------------------