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

public class ReaderInfo {
	public ReaderInfo()
	{
		
	}
	public Hashtable getReaderInfo(String ZJH)
	{
		DBBase db=new DBBase();
		Hashtable hs=new Hashtable();
		Connection conn=db.getConnection();
		String sql="select ReaderID,ZJH,GH,BZRQ,SXRQ,GQRQ,YJ,SXF,LJJS,RuleID,ZT from KJB2_KJXX_Reader where ZJH=?";
		PreparedStatement ps;
		try
		{
			ps=conn.prepareStatement(sql);
			ps.setString(1,ZJH);
			ResultSet rs=ps.executeQuery();
			while(rs.next())
			{
				ResultSetMetaData rsmd=rs.getMetaData();
				for(int i=0;i<rsmd.getColumnCount();i++)
				{
					hs.put(rsmd.getColumnName(i+1),rs.getObject(i+1));
				}
			}
		}
		catch(SQLException e)
		{
			e.printStackTrace();
		}
		db.closeDB(conn);
		return hs;
		
	}
	public int getUserPassword(String userPassword,String userName,String zjh)
	{
		DBBase dba=new DBBase();
		int i=0;
		Connection connection=dba.getConnection();
		String sql1="update KJB2_KJXX_User set userPassword=?,userName=? where ZJH=? and userType=1";
		PreparedStatement pst;
		try 
		{
			pst=connection.prepareStatement(sql1);
			pst.setString(1,userPassword);
			pst.setString(2,userName);
			pst.setString(3,zjh);
			
			i=pst.executeUpdate();
		} 
		catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		dba.closeDB(connection);
		System.out.println("IIIIIIIIII:"+i);
		return i;
			
	}

}