query.java

java编写小型超市管理系统+数据库.用于小型超市简单的货品进存销

package com.wish;
import java.sql.*;
import java.util.Vector;

import javax.swing.table.DefaultTableModel;
//查询物品的类
public class Query {
	
	public static void queryKind(String n)
	{
		DefaultTableModel dtm=new DefaultTableModel();
		dtm.addColumn("物品编号");
		dtm.addColumn("物品名称");
		dtm.addColumn("物品单位");
		dtm.addColumn("物品单价");
		dtm.addColumn("物品种类");
		
		Connection cn=ConnectionDB.getCon();
		Statement st=null;
		@SuppressWarnings("unused") ResultSet rs=null;
		
		try {
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
			st=cn.createStatement();
			rs=st.executeQuery("select * from itemlist where item_kind='"+n+"'");
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		ItemManager IM=new ItemManager();
		Vector v=IM.getItem();
		for(int i=0;i<v.size();i++)
		 {
			 Item item = (Item) v.get(i);
			 Object[]data = new Object[5];//表示一条记录
			 data[0] = item.getItem_id();
			 data[1] = item.getItem_name();
			 data[2] = item.getItem_dw();
			 data[3] = item.getItem_dj();
			 data[4] = item.getItem_kind();
			 
			 dtm.addRow(data);
		 }
	}public static void queryItem(String n)
	{
		DefaultTableModel dtm=new DefaultTableModel();
		dtm.addColumn("物品编号");
		dtm.addColumn("物品名称");
		dtm.addColumn("物品单位");
		dtm.addColumn("物品单价");
		dtm.addColumn("物品种类");
		
		Connection cn=ConnectionDB.getCon();
		Statement st=null;
		@SuppressWarnings("unused") ResultSet rs=null;
		try {
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
			st=cn.createStatement();
			rs=st.executeQuery("select * from itemlist where item_name='"+n+"'");
		} catch (ClassNotFoundException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		ItemManager IM=new ItemManager();
		Vector v=IM.getItem();
		for(int i=0;i<v.size();i++)
		 {
			 Item item = (Item) v.get(i);
			 Object[]data = new Object[5];//表示一条记录
			 data[0] = item.getItem_id();
			 data[1] = item.getItem_name();
			 data[2] = item.getItem_dw();
			 data[3] = item.getItem_dj();
			 data[4] = item.getItem_kind();
			 
			 dtm.addRow(data);
		 }
	}
}