librarianinfodao.java

用eclipse编写的图书管理系统

package sever.dao;

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

import sever.db.ConnectionDB;
import sever.entity.BookInfo;
import sever.entity.LibrarianInfo;

//添加管理员
public class LibrarianInfoDAO {
	public boolean addLibrarian(LibrarianInfo librarian){
		String sql="insert into LibrarianInfo values('"+librarian.getLibrarianName()+"','"+librarian.getLibrarianPass()+"','"+
		librarian.getLibrarianPosition()+"','"+librarian.getLibrarianSex()+"','"+librarian.getLibrarianAge()+"','"+
		librarian.getLibrarianTel()+"','"+librarian.getLibrarianAddress()+"','"+librarian.getLibrarianEmail()+"')";
		
		ConnectionDB con=new ConnectionDB();
		con.updateData(sql);
		System.out.println("成功");
		return true;
		
	}
	
	
	//删除管理员
	public boolean delect(LibrarianInfo bean){
//		delete from BookInfo where BookNumber=13
		String sql="delete  from LibrarianInfo where LibrarianId=('"+bean.getLibrarianId()+"')";
		ConnectionDB connectiondb=new ConnectionDB();
		connectiondb.updateData(sql);
		System.out.println("删除成功");
		return true;
	}
	
	
	public boolean delecttwo(LibrarianInfo bean){
		String sql="delete from LibrarianInfo where LibrarianName=('"+bean.getLibrarianName()+"')";
		ConnectionDB connectiondb=new ConnectionDB();
		connectiondb.updateData(sql);
		System.out.println("删除成功");
		return true;
	}
     //修改密码
	
	public boolean rework(LibrarianInfo bean){
		String sql="update LibrarianInfo set LibrarianPass=('"+bean.getLibrarianPass()+"') where LibrarianName=('"+bean.getLibrarianName()+"') ";
		ConnectionDB conn=new ConnectionDB();
		conn.updateData(sql);
		
		System.out.println(sql);
		return true;
	}
	
	//验证管理保员是否存按编号
	public boolean checkLibrNub(LibrarianInfo bean){
		boolean result1=false;
		String sql="select * from LibrarianInfo where LibrarianId=('"+bean .getLibrarianId()+"')";
		ConnectionDB con=new ConnectionDB();
		ResultSet rr=con.queryData(sql);
		System.out.println(sql);
		try {
			if(rr.next()){
				result1=true;
			}else{
				result1=false;
			}
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		return result1;
	}

	//验证管理员按姓名
	
	public boolean checkNamet(LibrarianInfo bean){
		boolean result1=false;
		String sql="select * from LibrarianInfo where LibrarianName=('"+bean .getLibrarianName()+"')";
		ConnectionDB con=new ConnectionDB();
		ResultSet rr=con.queryData(sql);
		System.out.println(sql);
		try {
			if(rr.next()){
				result1=true;
			}else{
				result1=false;
			}
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		return result1;
	}
//登陆验证按用
	public boolean enter(LibrarianInfo bean){
		boolean result=false;
		String sql="select Librarianpass from LibrarianInfo where LibrarianName=('"+bean .getLibrarianName()+"')";
		ConnectionDB con=new ConnectionDB();
		ResultSet rr=con.queryData(sql);
		System.out.println(sql);
		try {
			if(rr.next()){
				if(bean.getLibrarianPass().equals(rr.getString(1))){
					result=true;
				}else{
					result=false;
				}
			
			}else{
				result=false;
			}
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		return result;
	

	}
	
	
}