急！！学生管理系统连接数据库问题

basa188 2010-04-20 09:30:39

package shujuku;

import javax.swing.*;

import java.awt.*;
import java.awt.event.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class Studentjiemian extends JFrame
{
private JMenuBar mb;
private JMenu col;
private JMenuItem lu,xiu,cha,shan;
protected ResultSet rs;
Studentjiemian()
{
super("查询界面");
Container c=getContentPane();
JPanel northPanel=new JPanel();
mb=new JMenuBar();
col=new JMenu("菜单");
lu=new JMenuItem("录入");
xiu=new JMenuItem("修改");
cha=new JMenuItem("查询");
shan=new JMenuItem("删除");
lu.addActionListener(new Handler1());
xiu.addActionListener(new Handler1());
cha.addActionListener(new Handler1());
shan.addActionListener(new Handler1());
mb.add(col);
col.add(lu);
col.add(cha);
col.add(xiu);
col.add(shan);
setJMenuBar(mb);
setSize(400,300);
setVisible(true);

final JLabel l1=new JLabel();
add(scrollPane,BorderLayout.CENTER);
cha.addActionListener(new ActionListener(){

public void actionPerformed(ActionEvent event)
{

}
});

}

public static void main(String[] args)
{
new Studentjiemian();
}
class Handler1 implements ActionListener
{
public void actionPerformed(ActionEvent e)
{
if(e.getSource()==lu)
{
new LuRuStudent();
}

if(e.getSource()==cha)
{
new ChaXunStudent();
}
if(e.getSource()==shan)
{
new ShanChuStudent();
}
if(e.getSource()==xiu)
{
new XiuGaistudent();
}
}
}

}

package shujuku;

import java.sql.*;

public class ChaXunStudent {
public ChaXunStudent() {
String sql;
Connection conn;
Statement stmt;
ResultSet rs;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:class8_10";
String user = "";
String password = "";
conn = DriverManager.getConnection(url, user, password);
stmt = conn.createStatement();
sql = "select * from student";
rs = stmt.executeQuery(sql);
while (rs.next()) {
System.out.println(rs.getString(1)+" "+rs.getString(2)+" "+rs.getString(3));

}
rs.close();
stmt.close();
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}

}
请问各位高手怎样把数据库的信息输出到界面上。谢谢

...全文