userdaoimp.java

B2C的J2EE开发的 MVC +DAO 设计

package ldsj.gjm.Dao.imp;

import ldsj.gjm.Dao.userDao;
import ldsj.gjm.db.userdb;
import java.sql.*;
public class userDaoImp implements userDao
{
	public boolean isExist(String name,String pwd)
	{
		userdb udb=new userdb();
		Connection ucon=udb.getUserDB();
		boolean flag=false;
		try
		{
			PreparedStatement ps=ucon.prepareStatement("select * from userInfo where iname=? and [password]=?");	
		    ps.setString(1,name);
		    ps.setString(2,pwd);
		    ResultSet rs=ps.executeQuery();
		    flag=rs.next();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		return flag;
		
		
		
	}
	public String getRight(String name)
	{
		userdb udb=new userdb();
		Connection ucon=udb.getUserDB();
		String right="";
		ResultSet rs=null;
		PreparedStatement ps=null;
		try
		{
			ps=ucon.prepareStatement("select * from userInfo where iname=?");	
		    ps.setString(1,name);
		    rs=ps.executeQuery();
		   	rs.next();
		    right=rs.getString(10);
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		
	   try 
	   {
		rs.close();
		ps.close();
	  } 
	   catch (SQLException e) {
		
		e.printStackTrace();
	}
	 
	  return right;	
	  
		
	}
}