frame1.java~23~

一个关于列表框值的修改的源代码

package listsql;

import java.awt.*;
import javax.swing.*;
import java.awt.BorderLayout;
import java.awt.Rectangle;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.sql.SQLException;

public class Frame1
    extends JFrame {
  JPanel contentPane;
  DefaultListModel obj = new DefaultListModel();
  JList L1 = new JList(obj);
  public Frame1() {
    try {
      setDefaultCloseOperation(EXIT_ON_CLOSE);
      jbInit();
    }
    catch (Exception exception) {
      exception.printStackTrace();
    }
  }

  /**
   * 连接数据库的关键部分
   */
  public void l() {
    dbsql db = new dbsql();
    db.connect();
    String sql = "select * from zc";
    ResultSet rs = db.query(sql);

    ArrayList item = new ArrayList(); //声明动态数组

    try {
      if (rs != null) {
        while (rs.next()) {
          item.add(rs.getString(2));  //将结果集存入动态数组
        }
      }
    }
    catch (SQLException ex) {
      JOptionPane.showMessageDialog(null, ex.toString());
    }

    for (int i = 0; i < item.size(); i++) {
      obj.addElement(item.get(i));  //列表框将动态数组的内容载入
    }
    db.close();
  }

  /**
   * Component initialization.
   *
   * @throws java.lang.Exception
   */
  private void jbInit() throws Exception {
    contentPane = (JPanel) getContentPane();
    contentPane.setLayout(null);
    setSize(new Dimension(400, 300));
    setTitle("列表框绑定数据库实例");
    l();  //调用l方法
    L1.setBounds(new Rectangle(83, 33, 135, 180));
    contentPane.add(L1);

  }
}