adminrulemanageprocess.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 AdminRuleManageProcess {

	public AdminRuleManageProcess() {
		super();
		// TODO 自动生成构造函数存根
	}
	public void UpdataRuleManage(int RuleID,String GZMC,int KJYSJ,String KJYGCDID,int KXJSJ,int KXJCS,int KYYSJ)
	{
		DBBase db=new DBBase();
		Connection con=db.getConnection();
		String str="update KJB2_KJXX_Rule set GZMC=?,KJYSJ=?,KJYGCDID=?,KXJSJ=?,KXJCS=?,KYYSJ=? where RuleID=?";
		PreparedStatement ps;
		try {
			ps=con.prepareStatement(str);
			ps.setString(1,GZMC);
			ps.setInt(2,KJYSJ);
			ps.setString(3,KJYGCDID);
			ps.setInt(4,KXJSJ);
			ps.setInt(5,KXJCS);
			ps.setInt(6,KYYSJ);
			ps.setInt(7,RuleID);
			ps.execute();
			
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		db.closeDB(con);
	}
	public void DeleteRuleManage(int RuleID)
	{
		DBBase db=new DBBase();
		Connection con=db.getConnection();
		String str="delete from KJB2_KJXX_Rule where RuleID=?";
		PreparedStatement ps;
		try {
			ps=con.prepareStatement(str);
			ps.setInt(1,RuleID);
			ps.execute();
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		db.closeDB(con);
	}
	public void AddRuleManage(String GZMC,int KJYSJ,String KJYGCDID,int KXJSJ,int KXJCS,int KYYSJ)
	{
		DBBase db=new DBBase();
		Connection con=db.getConnection();
		String str="insert into KJB2_KJXX_Rule( GZMC, KJYSJ, KJYGCDID,KXJSJ, KXJCS, KYYSJ) values(?,?,?,?,?,?) ";
		PreparedStatement ps;
		try {
			ps=con.prepareStatement(str);
			ps.setString(1,GZMC);
			ps.setInt(2,KJYSJ);
			ps.setString(3,KJYGCDID);
			ps.setInt(4,KXJSJ);
			ps.setInt(5,KXJCS);
			ps.setInt(6,KYYSJ);
			ps.execute();
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		db.closeDB(con);
	}

	public Vector SelectRuleManage()
	{
		Vector vv=new Vector();
		Hashtable hs=null; 
		DBBase db=new DBBase();
		Connection con=db.getConnection();
		String str="select RuleID,GZMC, KJYSJ, KJYGCDID,KXJSJ, KXJCS, KYYSJ from KJB2_KJXX_Rule  ";
		ResultSet rs=null;
		ResultSetMetaData rsmd=null;
		PreparedStatement ps;
		try {
			ps=con.prepareStatement(str);
			rs=ps.executeQuery();
			rsmd=rs.getMetaData();
			while(rs.next())
			{
				hs=new Hashtable();
				for(int i=0;i<rsmd.getColumnCount();i++)
				{
					hs.put(rsmd.getColumnName(i+1),rs.getObject(i+1));
				}
				vv.add(hs);
			}
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		db.closeDB(con);
		return vv;
	}

}