adminiceborrowcardprocess.java

简单的图书馆管理系统

/***************
     作者：韩冰
     类型：Bean类
   类功能：
 完成日期：
 修改日期：
 ***************/
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.sql.Statement;
import java.util.Hashtable;
import java.util.Vector;

import com.common.DBParent.DBBase;

public class AdminICEBorrowCardProcess 
{

	public AdminICEBorrowCardProcess()
	{
		super();
		// TODO 自动生成构造函数存根
	}
	/*************  删除借阅证autor:金日新*1.6*******************/
	public boolean DeleteCertificate(String ZJH)
	{
		DBBase db=new DBBase();
		Connection con=db.getConnection();
		PreparedStatement ps=null;
		boolean n=false;
		String sql="delete from KJB2_KJXX_Reader where ZJH=?";
		String sql1="delete from KJB2_KJXX_User where ZJH=?";
		try
		{
			ps=con.prepareStatement(sql);
			ps.setString(1,ZJH);
			if(!ps.execute())
			{
				n=true;
			}
			ps=con.prepareStatement(sql1);
			ps.setString(1, ZJH);
			if(!ps.execute())
			{
				n=true;
			}
		}
		catch (SQLException e)
		{
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		db.closeDB(con);
		return n;
		
	}
/*************end-autor:金日新*1.6*******************/
	/*************	添加借阅证	*******************/
	public int insertBorrowCardPro(String ZJH,String GH,String BZRQ,String SXRQ,String GQRQ,String YJ,String SXF,int LJJS,int RuleID,String ZT)
	{
		int i=0;
		//连接数据库
		DBBase db=new DBBase();
		Connection conn=db.getConnection();
		//添加SQL语句
		String sql="insert into KJB2_KJXX_Reader(ZJH,GH,BZRQ,SXRQ,GQRQ,YJ,SXF,LJJS,RuleID,ZT) values(?,?,?,?,?,?,?,?,?,?)";
		String str="insert into KJB2_KJXX_User(ZJH,userName,userPassword,userType) values(?,?,?,?)";
		System.out.println(sql);
		PreparedStatement ps;
		try
		{
			ps=conn.prepareStatement(sql);
			ps.setString(1,ZJH);
			ps.setString(2,GH);
			ps.setDate(3,Date.valueOf(BZRQ));
			ps.setDate(4,Date.valueOf(SXRQ));
			ps.setDate(5,Date.valueOf(GQRQ));
			ps.setString(6,YJ);
			ps.setString(7,SXF);
			ps.setInt(8,111);
			ps.setInt(9,222);
			ps.setString(10,ZT);
			i=ps.executeUpdate();
			ps=conn.prepareStatement(str);
			ps.setString(1,ZJH);
			ps.setString(2,ZJH);
			ps.setString(3,ZJH);
			ps.setInt(4,1);
			i=ps.executeUpdate();
		}
		catch (SQLException e)
		{
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		db.closeDB(conn);
		return i;
	}
	
	/*****************	修改借阅证信息		********************/
	public int updateBorrowCardPro(String ZJH,String GH,String BZRQ,String SXRQ,String GQRQ,String YJ,String SXF,int LJJS,int RuleID,String ZT,String intemp)
	{
		int i=0;
//		连接数据库
		DBBase db=new DBBase();
		Connection conn=db.getConnection();
		//添加SQL语句
		String sql="update KJB2_KJXX_Reader set ZJH=?,GH=?,BZRQ=?,SXRQ=?,GQRQ=?,YJ=?,SXF=?,LJJS=?,RuleID=?,ZT=? where ZJH=?";
		String str="update KJB2_KJXX_User set ZJH=? where ZJH=?";
		System.out.println(sql);
		PreparedStatement ps;
		try
		{
			ps=conn.prepareStatement(sql);
			ps.setString(1,ZJH);
			ps.setString(2,GH);
			ps.setDate(3,Date.valueOf(BZRQ));
			ps.setDate(4,Date.valueOf(SXRQ));
			ps.setDate(5,Date.valueOf(GQRQ));
			ps.setString(6,YJ);
			ps.setString(7,SXF);
			ps.setInt(8,LJJS);
			ps.setInt(9,RuleID);
			ps.setString(10,ZT);
			ps.setString(11,intemp);
			i=ps.executeUpdate();
			
			ps=conn.prepareStatement(str);
			ps.setString(1,ZJH);
			ps.setString(2,intemp);
			
			i=ps.executeUpdate();
		}
		catch (SQLException e)
		{
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		db.closeDB(conn);
		return i;
	}
	
	/************  查看	********************/
	public Vector selectBorrowCardPro()
	{
		Vector vv=new Vector();
		Hashtable hs=null;
		DBBase db=new DBBase();
		Connection conn=db.getConnection();
		String sql="select ZJH,GH,BZRQ,SXRQ,GQRQ,YJ,SXF,LJJS,RuleID,ZT from KJB2_KJXX_Reader";
		ResultSet rs=null;
		ResultSetMetaData rsmd=null;
		
		try
		{
			Statement ps=conn.createStatement();
			rs=ps.executeQuery(sql);
			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(conn);
		System.out.println("bbbb"+vv);
		return vv;
	}
	
	public static void main(String[] args)
	{
		// TODO 自动生成方法存根
		//添加验证
		AdminICEBorrowCardProcess a=new AdminICEBorrowCardProcess();
//		a.insertBorrowCardPro("ZJH","GH","2006-01-02","2006-02-02","2006-03-02","YJ","SXF",111,222,"ZT");
		
		//修改验证
//		a.updateBorrowCardPro("aaaaa","fffff","2001-01-02","2001-02-02","2001-03-02","5555","f111",1231,123213,"abc","ss");
	}
	
}