adminstoreprocess.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 com.common.DBParent.DBBase;

public class AdminStoreProcess {

	public AdminStoreProcess() {
		super();
		// TODO 自动生成构造函数存根
	}
	public void updateStore(int BookID,int BookClassID,int StoreID,String SQH,String TMH,String NJH,String ZT,Date RGSJ)
	{  
		
		DBBase db=new DBBase();
		Connection con=db.getConnection();
		String str="update KJB2_KJXX_Store set BookClassID=?,StoreID=?,SQH=?,TMH=?,NJH=?,ZT=?,RGSJ=? where BookID=?";
		PreparedStatement ps=null;
		try {
			ps=con.prepareStatement(str);
			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);
			ps.setInt(8,BookID);
			ps.executeUpdate();
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		db.closeDB(con);
		
		
	}
	public Vector selectStore()
	{
		Vector vv=new Vector();
		Vector v=null;
		DBBase db=new DBBase();
		Connection con=db.getConnection();
		String str="select BookID,BookClassID,StoreID,SQH,TMH,NJH,ZT,RGSJ from KJB2_KJXX_Store ";
		ResultSet rs=null;
		ResultSetMetaData rsmd=null;
		PreparedStatement ps;
		try {
			ps=con.prepareStatement(str);
			rs=ps.executeQuery();
			rsmd=rs.getMetaData();
			while(rs.next())
			{
				v=new Vector();
				for(int i=0;i<rsmd.getColumnCount();i++)
				{
					v.add(rs.getObject(i+1));
				}
				
				vv.add(v);
			}
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		db.closeDB(con);
		return vv;
	}
	public void  deleteStore(int BookID)
	{
		DBBase db=new DBBase();
		Connection con=db.getConnection();
		String str="delete from KJB2_KJXX_Store where BookID=?";
		PreparedStatement ps;
		try {
			ps=con.prepareStatement(str);
			ps.setInt(1,BookID);
			ps.execute();
			
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		db.closeDB(con);
	}
	public void  insertStore(int BookClassID,int StoreID,String SQH,String TMH,String NJH,String ZT,Date RGSJ)
	{
		DBBase db=new DBBase();
		Connection con=db.getConnection();
		String str="insert into  KJB2_KJXX_Store (BookClassID,StoreID,SQH,TMH,NJH,ZT,RGSJ ) values (?,?,?,?,?,?,?)";
		PreparedStatement ps;
		try {
			ps=con.prepareStatement(str);
			
			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);
			ps.execute();
			
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		db.closeDB(con);
	}
	
}