productquery.java

软件工程课程设计

package Manager;
import javax.swing.*;

import com.borland.jbcl.layout.*;
import java.sql.*;   //引入包java.sql.*;
import javax.swing.table.*;//引入包sqljavax.swing.table.*;
import java.util.*;    //由于会用到Vector对象，引入包java.util.*;
import java.awt.event.*;

public class productQuery extends JFrame {
	/**
	 * <p>Title: 产品信息查询</p>
	 * <p>Description: </p>
	 * <p>Copyright: Copyright (c) 2008</p>
	 * <p>Company:南华大学计算机系 </p>
	 * @author 王云飞
	 * @version 1.0
	 */
	private static final long serialVersionUID = 1L;
ResultSet rs;    //定义结果集
  private DBManager db =new DBManager();

  XYLayout xYLayout1 = new XYLayout();
  JLabel jLabel1 = new JLabel();
  JScrollPane jScrollPane1 = new JScrollPane();
  //定义DefaultTableModel模型
   DefaultTableModel model =new DefaultTableModel();
   //定义JTable为DefaultTableModel的实例model模式
  JTable jTable1 = new JTable(model);

  public productQuery() {
    try {
      jbInit();
    }
    catch(Exception e) {
      e.printStackTrace();
    }
  }
  public static void main(String[] args) {
     new productQuery();
  }
  private void jbInit() throws Exception {
    jLabel1.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel1.setText("以下为所有商品信息列表");
    xYLayout1.setWidth(530);
    xYLayout1.setHeight(410);
    // model中加入列名
      model.addColumn("名称") ;
      model.addColumn("负责人") ;
      model.addColumn("部门") ;
      model.addColumn("单位") ;
      model.addColumn("单价") ;
      model.addColumn("描述") ;

    this.getContentPane().setLayout(xYLayout1);
    this.addWindowListener(new productQuery_this_windowAdapter(this));
    jTable1.setFont(new java.awt.Font("Dialog", 0, 16));
    jScrollPane1.setFont(new java.awt.Font("Dialog", 0, 16));
    this.setTitle("产品信息查询");
    this.getContentPane().add(jLabel1, new XYConstraints(24, 13, 332, 42));
    this.getContentPane().add(jScrollPane1, new XYConstraints(24, 63, 476, 300));
    jScrollPane1.getViewport().add(jTable1, null);
  }

  private void getResult(){
    //定义临时集合
   Vector<String> tempvector=new Vector<String>(1,1);
   String sql;
   //查询语句
   sql="select * from productinfo ";
  //执行数据库的查询操作
  rs =db.getResult(sql);
  try {
       //判断返回的结果集是否为空，若不为空显示每条记录
       boolean  isexist=false;
              try {
                       isexist = rs.first();
                       }
              catch (SQLException ex1) {
                       }
  //若有数据，显示
  if( isexist)
     {
      //移动游标到零的位置
       rs.beforeFirst();
       //逐条将查询结果显示在jtable中
       while(rs.next() )
      {tempvector=new Vector(1,1);
        tempvector.add(rs.getString("Name")) ;
        tempvector.add(rs.getString("Principal")) ;
        tempvector.add(rs.getString("Department")) ;
        tempvector.add(rs.getString("Units")) ;
        tempvector.add(rs.getString("Unitprice")) ;
        tempvector.add(rs.getString("Comment")) ;
          model.addRow(tempvector);
      }
    }
     //若无数据，显示警告对话框
    else
    {   JOptionPane.showMessageDialog(null,"无纪录!");              }
  }
  //若出现异常，弹出警告对话框
  catch (SQLException ex) { JOptionPane.showMessageDialog(null,"发生错误!");
  }

  }
  //在窗体显示时运行查询过程
  void this_windowOpened(WindowEvent e) {
           getResult();
  }
}

class productQuery_this_windowAdapter extends java.awt.event.WindowAdapter {
  productQuery adaptee;

  productQuery_this_windowAdapter(productQuery adaptee) {
    this.adaptee = adaptee;
  }
  public void windowOpened(WindowEvent e) {
    adaptee.this_windowOpened(e);
  }
}