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].setEdit
[1] [2] 下一页