readerinfodao.java

用eclipse编写的图书管理系统

package sever.dao;

import java.sql.ResultSet;
import java.sql.SQLException;

import sever.db.ConnectionDB;
import sever.entity.BorrowInfo;
import sever.entity.ReaderInfo;


//读者注册
public class ReaderInfoDAO {
	ResultSet r;
	ResultSet rr;
	public boolean saveReader(ReaderInfo reader){
		String  sql="insert into ReaderInfo values('"+reader.getReaderName()+"','"+reader.getReaderAge()+"','"+
		reader.getReaderJob()+"','"+reader.getReaderSex()+"','"+reader.getReaderAddress()+"','"+
		reader.getReaderTel()+"','"+reader.getReaderEmail()+"','"+reader.getReaderMoney()+"')" ; 
		
		
		ConnectionDB conn=new ConnectionDB();
		conn.updateData(sql);
		System.out.println("已成功注册！");
		return true;
		
	}
	//删除读者ID
	public boolean deletereader(ReaderInfo bean){
		String sql="delete from ReaderInfo where ReaderId=('"+bean.getReaderId()+"')";
		ConnectionDB connectiondb=new ConnectionDB();
		connectiondb.updateData(sql);
		System.out.println("删除成功");
		return true;
	}
	
	//删除读者Name
	
	public boolean deletereadertwo(ReaderInfo bean){
		String sql="delete from ReaderInfo where ReaderName=('"+bean.getReaderName()+"')";
		ConnectionDB connectiondb=new ConnectionDB();
		connectiondb.updateData(sql);
		System.out.println("删除成功");
		return true;
	}
	
	//按姓名查询读者
	public ResultSet SelectRead(ReaderInfo reader){
     
		
		try{
		String sql="select * from ReaderInfo where ReaderName like('"+reader.getReaderName()+"%')";
		ConnectionDB conn=new ConnectionDB();
		System.out.println(sql);
	      r=conn.queryData(sql);
		}catch(Exception ce){
			ce.getMessage();
		}
		return r;
	}
	
	//按编号查询读者
	
	public ResultSet SelectNumber(ReaderInfo reader){
		try{
			String sql="select *from ReaderInfo where ReaderId=('"+reader.getReaderId()+"')";
			ConnectionDB connectiondb=new ConnectionDB();
			rr=connectiondb.queryData(sql);
		}catch(Exception e){
			e.getMessage();
		}
		return rr;
	}
	//按编号验证读者
 public boolean saveto(ReaderInfo  readd){
	 boolean result=false;
	 ConnectionDB conne=new ConnectionDB();
	 String sql="select * from ReaderInfo where ReaderId="+readd.getReaderId();
	 ResultSet rs=conne.queryData(sql);
	 
	 try {
		if(rs.next()){
			System.out.println("用户存在");
			 result=true;
		 }else{
			 result=false;
		 }
	} catch (SQLException e) {
		// TODO 自动生成 catch 块
		e.printStackTrace();
	}
	 return result;
 }
	
	//按姓名验;证读者
 
 public boolean savetoo(ReaderInfo readd){
	 boolean result=false;
	 ConnectionDB connne=new ConnectionDB();
	 String sql="select * from ReaderInfo where ReaderName=('"+readd.getReaderName()+"')";
	 ResultSet rs=connne.queryData(sql);
	 
	 try {
		if(rs.next()){
			 result=true;
		 }else{
			 result=false;
		 }
	} catch (SQLException e) {
		// TODO 自动生成 catch 块
		e.printStackTrace();
	}
	return result;
 }

	//显示读者照片
	public boolean photo(ReaderInfo read){
		
		boolean result=false;
		String sql="select ReaderName from ReaderInfo where ReaderName=('"+read.getReaderName()+"')";
		ConnectionDB co=new ConnectionDB();
		ResultSet rs=co.queryData(sql);
		try {
	
			if(rs.next()){
				if(read.getReaderName().equals(rs.getString(1))){
					
					result=true;
				}else{
					result=false;
					
				}
				
			}else{
				result=false;
				
			}
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		return result;
		
		
	}

}