admininstoreroomprocess.java

简单的图书馆管理系统

package com.common.DBaccess;

import java.sql.Connection;
import java.sql.Date;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Hashtable;
import java.util.Vector;

import javax.swing.JOptionPane;

import com.common.DBParent.DBBase;

public class AdminInStoreroomProcess {

	public AdminInStoreroomProcess() {
		super();
		// TODO 自动生成构造函数存根
	}
	public void updateInStoreroom(int BookClassID,String Title,String Author,String ISBN,String CBFXX,String ZTXX,String DTZRZ,String ZRZ,String ZGTSFLFLH,String KTTSFLFLH,String LTZT,String FZX,Date CBSJ,String DJ,String PCJE)
	{  
		
		DBBase db=new DBBase();
		Connection con=db.getConnection();
		String str="update KJB2_KJXX_BOOK set Title=?,Author=?,ISBN=?,CBFXX=?,ZTXX=?,DTZRZ=?,ZRZ=?,ZGTSFLFLH=?,KTTSFLFLH=?,LTZT=?,FZX=?,CBSJ=?,DJ=?,PCJE=? where BookClassID=?";
		PreparedStatement ps;
		try {
			ps=con.prepareStatement(str);
			ps.setString(1,Title);
			ps.setString(2,Author);
			ps.setString(3,ISBN);
			ps.setString(4,CBFXX);
			ps.setString(5,ZTXX);
			ps.setString(6,DTZRZ);
			ps.setString(7,ZRZ);
			ps.setString(8,ZGTSFLFLH);
			ps.setString(9,KTTSFLFLH);
			ps.setString(10,LTZT);
			ps.setString(11,FZX);
			ps.setDate(12,CBSJ);
			ps.setString(13,DJ);
			ps.setString(14,PCJE);
			ps.setInt(15,BookClassID);
			ps.execute();
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		db.closeDB(con);
		
		
	}
	public Vector selectInStoreroom()
	{
		Vector vv=new Vector();
		Hashtable ht=null; 
		DBBase db=new DBBase();
		Connection con=db.getConnection();
		String str="select BookClassID,Title,Author,ISBN,CBFXX,ZTXX,DTZRZ,ZRZ,ZGTSFLFLH,KTTSFLFLH,LTZT,FZX,CBSJ,DJ,PCJE from KJB2_KJXX_BOOK  ";
		ResultSet rs=null;
		ResultSetMetaData rsmd=null;
		PreparedStatement ps;
		try {
			ps=con.prepareStatement(str);
			rs=ps.executeQuery();
			rsmd=rs.getMetaData();
			while(rs.next())
			{
				ht=new Hashtable();
				for(int i=0;i<rsmd.getColumnCount();i++)
				{
					ht.put(rsmd.getColumnName(i+1),rs.getObject(i+1));
				}
				vv.add(ht);
			}
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		db.closeDB(con);
		return vv;
	}
	public void  deleteInStoreroom(int BookClassID)
	{
		DBBase db=new DBBase();
		Connection con=db.getConnection();
		String str="delete from KJB2_KJXX_BOOK where BookClassID=?";
		PreparedStatement ps;
		try {
			ps=con.prepareStatement(str);
			ps.setInt(1,BookClassID);
			ps.execute();
			
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		db.closeDB(con);
	}
	public void  insertInStoreroom(String Title,String Author,String ISBN,String CBFXX,String ZTXX,String DTZRZ,String ZRZ,String ZGTSFLFLH,String KTTSFLFLH,String LTZT,String FZX,Date CBSJ,String DJ,String PCJE)
	{
		DBBase db=new DBBase();
		Connection con=db.getConnection();
		String str="insert into  KJB2_KJXX_BOOK (Title,Author,ISBN,CBFXX,ZTXX,DTZRZ,ZRZ,ZGTSFLFLH,KTTSFLFLH,LTZT,FZX,CBSJ,DJ,PCJE ) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
		PreparedStatement ps;
		try {
			ps=con.prepareStatement(str);
			
			ps.setString(1,Title);
			ps.setString(2,Author);
			ps.setString(3,ISBN);
			ps.setString(4,CBFXX);
			ps.setString(5,ZTXX);
			ps.setString(6,DTZRZ);
			ps.setString(7,ZRZ);
			ps.setString(8,ZGTSFLFLH);
			ps.setString(9,KTTSFLFLH);
			ps.setString(10,LTZT);
			ps.setString(11,FZX);
			ps.setDate(12,CBSJ);
			ps.setString(13,DJ);
			ps.setString(14,PCJE);
			ps.execute();
			
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		db.closeDB(con);
	}
	public void InStoreroom(int BookClassID,int StoreID,String SQH,String TMH,String NJH,String ZT ,Date RGSJ)
	{   
		int i;
		DBBase db=new DBBase();
		Connection con=db.getConnection();
		String sql="Insert into KJB2_KJXX_Store (BookClassID,StoreID,SQH,TMH,NJH,ZT,RGSJ) values (?,?,?,?,?,?,?) ;";
		PreparedStatement ps;
		try {
			ps=con.prepareStatement(sql);
			
			ps.setInt(1,BookClassID);
			ps.setInt(2,StoreID);
			ps.setString(3,SQH);
			ps.setString(4,TMH);
			ps.setString(5,NJH);
			ps.setString(6,ZT);
			ps.setDate(7,RGSJ);
			i=ps.executeUpdate();
			
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		db.closeDB(con);
		
	}
	public ArrayList StorePlaceName()
	{
		ArrayList StorePlace=new ArrayList();;
		ArrayList al=null;
		PreparedStatement ps=null;
		ResultSet rs=null;
		DBBase db=new DBBase();
		Connection con=db.getConnection();
		String str="select StoreID from KJB2_KJXX_StorePlace";
		
		try {

			ps=con.prepareStatement(str);
			rs=ps.executeQuery();
			ResultSetMetaData rsmd=rs.getMetaData();
			while(rs.next())
			{
				al=new ArrayList();
				for(int i=0;i<rsmd.getColumnCount();i++)
				{
					al.add(rs.getObject(i+1));
				}
				StorePlace.add(al);
			}
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		db.closeDB(con);
		return StorePlace;
	}
	
	
}