adminstoreplaceprocess.java

简单的图书馆管理系统

package com.common.DBaccess;

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

import com.common.DBParent.DBBase;

public class AdminStorePlaceProcess {

	public AdminStorePlaceProcess() {
		super();
		// TODO 自动生成构造函数存根
	}
	public void updateStorePlace(int StoreID,String MC,String WZ,String FZR,String SM)
	{  
		
		DBBase db=new DBBase();
		Connection con=db.getConnection();
		String str="update KJB2_KJXX_StorePlace set  MC=?,WZ=?,FZR=?,SM=? where StoreID=?";
		PreparedStatement ps;
		try {
			ps=con.prepareStatement(str);
			ps.setString(1,MC);
			ps.setString(2,WZ);
			ps.setString(3,FZR);
			ps.setString(4,SM);
			ps.setInt(5,StoreID);
			ps.execute();
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		db.closeDB(con);
		
		
	}
	public Vector selectStorePlace()
	{
		Vector vv=new Vector();
		Hashtable ht=null; 
		DBBase db=new DBBase();
		Connection con=db.getConnection();
		String str="select StoreID,MC,WZ,FZR,SM from KJB2_KJXX_StorePlace  ";
		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  deleteStorePlace(int StoreID)
	{
		DBBase db=new DBBase();
		Connection con=db.getConnection();
		String str="delete from KJB2_KJXX_StorePlace where StoreID=?";
		PreparedStatement ps;
		try {
			ps=con.prepareStatement(str);
			ps.setInt(1,StoreID);
			ps.execute();
			
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		db.closeDB(con);
	}
	public void  insertStorePlace(String MC,String WZ,String FZR,String SM)
	{
		DBBase db=new DBBase();
		Connection con=db.getConnection();
		String str="insert into  KJB2_KJXX_StorePlace (MC,WZ,FZR,SM ) values (?,?,?,?)";
		PreparedStatement ps;
		try {
			ps=con.prepareStatement(str);
			
			ps.setString(1,MC);
			ps.setString(2,WZ);
			ps.setString(3,FZR);
			ps.setString(4,SM);
			ps.execute();
			
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		db.closeDB(con);
	}
	
	

}