usersdao.java

稿件名称：基于JAVA的JNDI技术和反射机制 稿件作者：段谟意 源代码名称：WEB-INF 调试环境：Win XP；Tomcat, JVM:JDK 1.5.2

package ddd.com.db;
import java.sql.*;
import ddd.com.domain.*;
public class UsersDAO
{
	private String selectUser="select name,password,email from users where name=? and password=?";
	private String insertUser="insert users (name,password,email) values(?,?,?)";
	public User getUser(String name,String password)
	{
		Connection conn=null;
		try
		{
			PubsConnection pubs=new PubsConnection();
			conn=pubs.getConnection();
			PreparedStatement psmt=conn.prepareStatement(selectUser);
			psmt.setString(1,name);
			psmt.setString(2,password);
			ResultSet rs=psmt.executeQuery();
			if(rs.next())
			{
				User user=new User();
				user.setName(rs.getString(1));
				user.setPassword(rs.getString(2));
				user.setEmail(rs.getString(3));
				return user;
			}
		}
		catch(Exception e)
		{
		}
		finally
		{
			try
			{
				if(conn!=null)
					conn.close();
			}
			catch(Exception ignore)
			{
			}
		}
		return null;
	}
	public int insertUser(User user)
	{
		Connection conn=null;
		int count=0;
		try
		{
			PubsConnection pubs=new PubsConnection();
			conn=pubs.getConnection();
			PreparedStatement psmt=conn.prepareStatement(insertUser);
			psmt.setString(1,user.getName());
			psmt.setString(2,user.getPassword());
			psmt.setString(3,user.getEmail());
			count=psmt.executeUpdate();
		}
		catch(Exception e)
		{
			
		}
		finally
		{
			try
			{
				if(conn!=null)
					conn.close();
			}
			catch(Exception ignore)
			{
			}
			return count;
		}		
	}
}