usermanager.java

基于java/mysql的图书管理系统,主要使用的技术有java+jsp+tomcat+mysql+eclipse jdk版本1.6.0

package com.zyuntao.struts.model;
import java.sql.*;
import java.util.*;

import com.zyuntao.struts.database.*;
import com.zyuntao.struts.form.*;
public class UserManager {
    Condatabase datasource;
	public UserManager()
	{	
	}
	public UserManager(Condatabase datasource)
	{	
		this.datasource = datasource;
	}
	//一般用户登陆
	public UserForm userlogin(String username,String password) throws SQLException
	{   		
		UserForm user=new UserForm();
		Condatabase datasource=new Condatabase();
	Connection conn=datasource.getConnection();
	String sql="select userid,username,password,email " +
			"from userlist " +
			"where admin=0 and username=?";
	PreparedStatement ps = null;
	ResultSet rs=null;
	try{
		ps=conn.prepareStatement(sql);
		ps.setString(1,username);
		rs=ps.executeQuery();
		if(rs.next())
		{
			
			user.setUserid(rs.getInt("userid"));
			user.setUsername(rs.getString("username"));
			user.setPassword(rs.getString("password"));
			user.setEmail(rs.getString("email"));
		}
			
	}
	finally{
		if (rs != null) {
			try {
				rs.close();
			} catch (SQLException e) {
			}
		}

		if (ps != null) {
			try {
				ps.close();
			} catch (SQLException e) {
			}
		}

		if (conn != null) {
			try {
				conn.close();
			} catch (SQLException e) {
			}
		
	}
	}
	if(username.equals(user.getUsername())&&password.equals(user.getPassword()))
	{
		return user;
	}
	return null;
	}
	
	//管理员登陆验证
	public UserForm adminlogin(String username,String password) throws SQLException
	{
		UserForm user=new UserForm();
		Condatabase datasource=new Condatabase();
	Connection conn=datasource.getConnection();
	String sql="select userid,username,password,email from userlist where admin=1 and username=?";
	PreparedStatement ps = null;
	ResultSet rs=null;
	try{
		ps=conn.prepareStatement(sql);
		ps.setString(1,username);
		rs=ps.executeQuery();
		if(rs.next())
		{
			user.setUserid(rs.getInt("userid"));
			user.setUsername(rs.getString("username"));
			user.setPassword(rs.getString("password"));
			user.setEmail(rs.getString("email"));
		}
			
	}
	finally{
		if (rs != null) {
			try {
				rs.close();
			} catch (SQLException e) {
			}
		}

		if (ps != null) {
			try {
				ps.close();
			} catch (SQLException e) {
			}
		}

		if (conn != null) {
			try {
				conn.close();
			} catch (SQLException e) {
			}
		
	}
	}
	if(username.equals(user.getUsername())&&password.equals(user.getPassword()))
	{
		return user;
	}
	return null;
}
	public UserForm register(String username,String password,String email) throws SQLException
	{
		UserForm user=new UserForm();
		Condatabase datasource=new Condatabase();
	Connection conn=datasource.getConnection();
	String sql="insert into userlist (username,password,email,admin) values (?,?,?,0);";
	PreparedStatement ps = null;
	try{ps=conn.prepareStatement(sql);
	ps.setString(1,username);
	ps.setString(2,password);
	ps.setString(3,email);
	ps.executeUpdate();
	}
	finally {

		if (ps != null) {
			try {
				ps.close();
			} catch (SQLException e) {
			}
		}

		if (conn != null) {
			try {
				conn.close();
			} catch (SQLException e) {
			}
		}
	}
	user.setUsername(username);
	user.setPassword(password);
	user.setEmail(email);
	return user;
	}
	public boolean checkuser(String userName) throws SQLException {
Condatabase datasource=new Condatabase();
		Connection conn = datasource.getConnection();

		String sql = "select * from userlist where username = ?";
		PreparedStatement ps = null;
		ResultSet rs = null;
		try {

			ps = conn.prepareStatement(sql);
			ps.setString(1, userName);
			rs = ps.executeQuery();
			if (rs.next()) {
				return true;
			}
		} finally {

			if (rs != null) {
				try {
					rs.close();
				} catch (SQLException e) {
				}
			}

			if (ps != null) {
				try {
					ps.close();
				} catch (SQLException e) {
				}
			}

			if (conn != null) {
				try {
					conn.close();
				} catch (SQLException e) {
				}
			}
		}
		return false;
	}
	
public Collection userlist() throws SQLException
{
	
	Condatabase datasource=new Condatabase();
	Connection conn=datasource.getConnection();
	String sql="select * from userlist where admin=0 order by userid asc";
	Statement stmt=null;
	ResultSet rs=null;
	Collection UserForm=new ArrayList();
	try{stmt = conn.createStatement();
	rs = stmt.executeQuery(sql);
	while(rs.next()){
	UserForm user=new UserForm();
	user.setUserid(rs.getInt("userid"));
	user.setUsername(rs.getString("username"));
	user.setPassword(rs.getString("password"));
	user.setEmail(rs.getString("email"));
	UserForm.add(user);
	}}
	finally {

		if (rs != null) {
			try {
				rs.close();
			} catch (SQLException e) {
			}
		}

		if (stmt != null) {
			try {
				stmt.close();
			} catch (SQLException e) {
			}
		}

		if (conn != null) {
			try {
				conn.close();
			} catch (SQLException e) {
			}
		}
	}
	return UserForm ;	
	}
public boolean deluser(int userid) throws SQLException
{Condatabase datasource=new Condatabase();
Connection conn=datasource.getConnection();
String sql1="select username from userlist where userid=? and admin=0";
String sql2="delete from userlist where userid=?";
String sql3="update booklist set borrow=0,username=null where username=?";
PreparedStatement ps=null;
PreparedStatement ps2=null;
PreparedStatement ps3=null;
ResultSet rs=null;
UserForm user=new UserForm();
boolean i;
try{
	ps=conn.prepareStatement(sql1);
	ps.setInt(1,userid);
	rs=ps.executeQuery();
	
	if(rs.next())
		
	{
		
		user.setUsername(rs.getString("username"));
{
	}
}if(user.getUsername()!=null){
String username=user.getUsername();
ps2=conn.prepareStatement(sql2);
ps3=conn.prepareStatement(sql3);
ps2.setInt(1,userid);
ps3.setString(1,username);
ps2.executeUpdate();
ps3.executeUpdate();


i=true;
}else
{i=false;}}
finally{
	if(rs !=null){try{
		rs.close();}
		catch(SQLException e){}}
		if(ps !=null){try{
			ps.close();}
			catch(SQLException e){}}
    	if(ps2 !=null){try{
    		ps2.close();}
    		catch(SQLException e){}}
    	if(ps3 !=null){try{
    		ps3.close();}
    		catch(SQLException e){}}
	    	if (conn != null) {
	    		try {
	    			conn.close();
	    		} catch (SQLException e) {
	    		}
	    	}
}
return i;
}
}