productquery.java

鞋类企业信息管理系统Java,这是一个毕业设计

import java.sql.*;
import java.awt.*;
import java.awt.event.*;

import javax.swing.*;
import javax.swing.table.*;
import java.util.*;
public class ProductQuery extends JFrame{

	ResultSet rs;    //声明结果集
	private DB_Manager db =new DB_Manager();
	JLabel jLabel1 = new JLabel("以下为所有商品信息列表:");
	JScrollPane jScrollPane1 = new JScrollPane();
	  //定义DefaultTableModel模型
	   DefaultTableModel model =new DefaultTableModel();
	   //定义JTable为DefaultTableModel的实例model模式
	 JTable jTable1 = new JTable(model);
     
     private void makeGUI() throws Exception {
    	 Container cp = this.getContentPane();
    	 cp.setLayout(new BorderLayout());
    	 cp.add(jLabel1,BorderLayout.NORTH);
    	 model.addColumn("名称") ;
         model.addColumn("负责人") ;
         model.addColumn("部门") ;
         model.addColumn("单位") ;
         model.addColumn("单价") ;
         model.addColumn("描述") ;
         cp.add(jScrollPane1,BorderLayout.CENTER);
         jScrollPane1.getViewport().add(jTable1, null);
         this.addWindowListener(new ProductQuery_this_windowAdapter(this));


     }
     
     private void getResult(){
    	    //定义临时集合
    	   Vector tempvector=new Vector(1,1);
    	   String sql;
    	   //查询语句
    	   sql="select * from productinfo ";
    	  //执行数据库的查询操作
    	  rs =db.getResult(sql);
    	  try {
    	       //判断返回的结果集是否为空，若6不为空显示每条记录
    	       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();
    	  }

     public void exit(){
    	 this.dispose();
     }
     
	 public ProductQuery(String title){
		 super(title);
		 try {
		      makeGUI();
		    }
		    catch(Exception e) {
		      e.printStackTrace();
		    }
        addWindowListener(new WinLis());
	 }
	 
	 class WinLis extends WindowAdapter
		{
			public void windowClosing(WindowEvent e)
			{
				exit();
			}
		}
	 
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		ProductQuery newQuery= new ProductQuery("产品信息查询");
		newQuery.validate();
		newQuery.setBounds(125,130,500,500);
		newQuery.setVisible(true);
	}

}
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);
	  }
	}