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

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) { System.out