adminprocess.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 AdminProcess {

	public AdminProcess() {
		// TODO 自动生成构造函数存根
	}
	public void updateAdmin(int userID,String userName,String userPassword,int userType)
	{  
		
		DBBase db=new DBBase();
		Connection con=db.getConnection();
		String str="update KJB2_KJXX_User set userName=?,userPassword=?,userType=? where userID=?";
		PreparedStatement ps;
		try {
			ps=con.prepareStatement(str);
			ps.setString(1,userName);
			ps.setString(2,userPassword);
			ps.setInt(3,userType);
			ps.setInt(4,userID);
			ps.execute();
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		db.closeDB(con);
		
		
	}
	public Vector selectAdmin()
	{
		Vector vv=new Vector();
		Hashtable ht=null; 
		DBBase db=new DBBase();
		Connection con=db.getConnection();
		String str="select userID,userName,userPassword,userType from KJB2_KJXX_User where userType=2";
		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 userID)
	{
		DBBase db=new DBBase();
		Connection con=db.getConnection();
		String str="delete from KJB2_KJXX_User where userID=?";
		PreparedStatement ps;
		try {
			ps=con.prepareStatement(str);
			ps.setInt(1,userID);
			ps.execute();
			
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		db.closeDB(con);
	}
	public void  insertInStoreroom(String userName,String userPassword,int userType)
	{
		DBBase db=new DBBase();
		Connection con=db.getConnection();
		String str="insert into  KJB2_KJXX_User (userName,userPassword,userType) values (?,?,?)";
		PreparedStatement ps;
		try {
			ps=con.prepareStatement(str);
			ps.setString(1,userName);
			ps.setString(2,userPassword);
			ps.setInt(3, userType);
			ps.execute();
			
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		db.closeDB(con);
	}
	public int queryAdminUserID(String userName)
	{
		int userID=0;
		DBBase db=new DBBase();
		Connection con=db.getConnection();
		String str="select userID from KJB2_KJXX_User where userName=?";
		ResultSet rs=null;
		PreparedStatement ps=null;
		try {
			ps=con.prepareStatement(str);
			ps.setString(1, userName);
			rs=ps.executeQuery();
			while(rs.next())
			{
				userID=rs.getInt(1);
			}
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		db.closeDB(con);
		return userID;
	}
	
}