java swing数据库_使用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---------------------