如题,我就想实现一点显示键,中间区域就出来一张表,显示数据库的内容,求高手啊!源代码如下:
//Manage.javaimport javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;public class Manage extends JFrame implements ActionListener{
Connection con;
Statement sql;
ResultSet rs;
JFrame f;
Object info[][],a[][];
JTable table;
JPanel p1,p2;
JLabel juser,jpsw;
JTextField user,psw;
JButton show,look,insert,delete,update,back;
public Manage(){
f = new JFrame("帐号管理");
f.setBounds(165,80,700,350);
f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
//info = new Object[30][2];
//Object name[] = {"用户名","密码"};
//table = new JTable(info,name);
p1 = new JPanel();
p2 = new JPanel();
user = new JTextField(15);
psw = new JTextField(15);
juser = new JLabel("用户名");
jpsw = new JLabel("密码");
show = new JButton("显示");
look = new JButton("查找");
insert = new JButton("添加");
delete = new JButton("删除");
update = new JButton("修改");
back = new JButton("返回");
p1.add(juser);
p1.add(user);
p1.add(jpsw);
p1.add(psw);
p2.add(show);
p2.add(look);
p2.add(insert);
p2.add(delete);
p2.add(update);
p2.add(back);
show.addActionListener(this);
look.addActionListener(this);
insert.addActionListener(this);
delete.addActionListener(this);
update.addActionListener(this);
back.addActionListener(this);
f.add(p1,BorderLayout.NORTH);
f.add(new JScrollPane(table),BorderLayout.CENTER);
f.add(p2,BorderLayout.SOUTH);
f.setVisible(true);
validate();
}
public void actionPerformed(ActionEvent e){
if(e.getSource()==show){
try{
con = DriverManager.getConnection("jdbd:odbc:TBook","","");
sql = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs = sql.executeQuery("SELECT * FROM login");
rs.last();
int lastNumber = rs.getRow();
a = new Object[lastNumber][2];
int k=0;
rs.beforeFirst();
while(rs.next()){
a[k][0]=rs.getString(1);
a[k][1]=rs.getString(2);
k++;
}
con.close();
}catch(SQLException ee){System.out.println(ee);}
Object name[] = {"用户名","密码"};
table =new JTable(a,name);
f.add(new JScrollPane(table),BorderLayout.CENTER);
}
else if(e.getSource()==show){
}
else if(e.getSource()==look){
}
else if(e.getSource()==insert){
}
else if(e.getSource()==delete){
}
else if(e.getSource()==update){
}
else if(e.getSource()==back){
new Admin();
f.setVisible(false);
}
}
public static void main(String args[]){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){System.out.println(""+e);}
new Manage();
}
}
//Manage.javaimport javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;public class Manage extends JFrame implements ActionListener{
Connection con;
Statement sql;
ResultSet rs;
JFrame f;
Object info[][],a[][];
JTable table;
JPanel p1,p2;
JLabel juser,jpsw;
JTextField user,psw;
JButton show,look,insert,delete,update,back;
public Manage(){
f = new JFrame("帐号管理");
f.setBounds(165,80,700,350);
f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
//info = new Object[30][2];
//Object name[] = {"用户名","密码"};
//table = new JTable(info,name);
p1 = new JPanel();
p2 = new JPanel();
user = new JTextField(15);
psw = new JTextField(15);
juser = new JLabel("用户名");
jpsw = new JLabel("密码");
show = new JButton("显示");
look = new JButton("查找");
insert = new JButton("添加");
delete = new JButton("删除");
update = new JButton("修改");
back = new JButton("返回");
p1.add(juser);
p1.add(user);
p1.add(jpsw);
p1.add(psw);
p2.add(show);
p2.add(look);
p2.add(insert);
p2.add(delete);
p2.add(update);
p2.add(back);
show.addActionListener(this);
look.addActionListener(this);
insert.addActionListener(this);
delete.addActionListener(this);
update.addActionListener(this);
back.addActionListener(this);
f.add(p1,BorderLayout.NORTH);
f.add(new JScrollPane(table),BorderLayout.CENTER);
f.add(p2,BorderLayout.SOUTH);
f.setVisible(true);
validate();
}
public void actionPerformed(ActionEvent e){
if(e.getSource()==show){
try{
con = DriverManager.getConnection("jdbd:odbc:TBook","","");
sql = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs = sql.executeQuery("SELECT * FROM login");
rs.last();
int lastNumber = rs.getRow();
a = new Object[lastNumber][2];
int k=0;
rs.beforeFirst();
while(rs.next()){
a[k][0]=rs.getString(1);
a[k][1]=rs.getString(2);
k++;
}
con.close();
}catch(SQLException ee){System.out.println(ee);}
Object name[] = {"用户名","密码"};
table =new JTable(a,name);
f.add(new JScrollPane(table),BorderLayout.CENTER);
}
else if(e.getSource()==show){
}
else if(e.getSource()==look){
}
else if(e.getSource()==insert){
}
else if(e.getSource()==delete){
}
else if(e.getSource()==update){
}
else if(e.getSource()==back){
new Admin();
f.setVisible(false);
}
}
public static void main(String args[]){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){System.out.println(""+e);}
new Manage();
}
}
报错内容:
求高手帮下忙啊,小弟第一次发帖子,不懂之处还请各位见谅啊。