productquery.java

本源码主要有主界面模块,操作员管理,产品信息管理,入库操作,出库操作,库存信息管理,数据操作模块组成,数据库为ACCESS2003.

package Manager;

import javax.swing.*;

import com.borland.jbcl.layout.*;
import java.awt.*;
import java.sql.*;   //引入包java.sql.*;
import javax.swing.table.*;//引入包sqljavax.swing.table.*;
import java.util.*;    //由于会用到Vector对象，引入包java.util.*;
import java.awt.event.*;
/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2003</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */

public class productQuery extends JFrame {
  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) {
    productQuery productQuery = new productQuery();
  }
  private void jbInit() throws Exception {
    jLabel1.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel1.setText("以下为所有商品信息列表");
    xYLayout1.setWidth(531);
    xYLayout1.setHeight(407);
    // 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(25, 63, 476, 320));
    jScrollPane1.getViewport().add(jTable1, null);
  }

  private void getResult(){
    //定义临时集合
   Vector tempvector=new Vector(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);
  }
}