java读取数据库数据放入list中_Java实现从数据库读取数据放入JList中.doc

Java实现从数据库读取数据放入JList中

import java.awt.*;

import java.sql.*;

import javax.swing.*;

import java.awt.event.*;

public class JTest

extends JFrame {

BorderLayout borderLayout1 = new BorderLayout();

DefaultListModel lm=new DefaultListModel();

JPanel jPanel1 = new JPanel();

JPanel jPanel2 = new JPanel();

JScrollPane jScrollPane1 = new JScrollPane();

JLabel label3=new JLabel("与主题相关的网页");

JList jlist1=new JList();

JButton jButton1 = new JButton();

Connection con;

int columnCount;

Statement st;

ResultSet rs;

public JTest() {

super("TopicCrawler");

try {

jbInit();

}

catch (Exception exception) {

}

}

private void jbInit() throws Exception {

this.setDefaultCloseOperation(EXIT_ON_CLOSE);

getContentPane().setLayout(borderLayout1);

jPanel1.setLayout(null);

jPanel2.setBounds(200,30,400,320);

jPanel2.setLayout(null);

label3.setBounds(310,10, 200, 25);

jButton1.setBounds(new Rectangle(350, 390, 100, 24));

jScrollPane1.setBounds(new Rectangle(10, 10, 370, 300));

jButton1.setText("显示结果");

jButton1.addActionListener(new ListFrame_jButton1_actionAdapter(this));

this.getContentPane().add(jPanel1, java.awt.BorderLayout.CENTER);

jlist1.setModel(lm);

jPanel1.add(label3);

jPanel1.add(jPanel2);

jPanel1.add(jButton1);

jPanel2.add(jScrollPane1);

jScrollPane1.getViewport().add(jlist1);

Class.forName("com.mysql.jdbc.Driver").newInstance();

con = (Connection) DriverManager.getConnection(

"jdbc:mysql://localhost:3306/crawler", "root", "root");

st = con.createStatement();

this.setSize(800,500);

this.setVisible(true);

}

public static void main(String[] args) {

JTest test = new JTest();

}

public void jButton1_actionPerformed(ActionEvent actionEvent) {

try {

rs=st.executeQuery("select * from complete_list");

while (rs.next()) {

lm.addElement( rs.getString(2));

}

}

catch (SQLException ex) {