userdao.java

来自「法改革开放的离开概率地方了过了的开始了开放个蒂法个饭店抒发个」· Java 代码 · 共 31 行

package dboprartion;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.PreparedStatement;
import entity.User;
public class UserDao {

	public UserDao() {}
	/**
	 * 数据库的连接以及查询
	 * @param name
	 * @return
	 */
    public User findname(String name){
    	User user=null;
    	try{
    		Connection cn=BaseDao.dbCn();
    		PreparedStatement ps=cn.prepareStatement("select * from User where name='"+name+"'");
    		ResultSet rs=ps.executeQuery();
    		while(rs.next()){
    		 user=new User();
    			user.setName(rs.getString(1));
    			user.setPass(rs.getString(2));
    		}
    	}catch(Exception e){
    		System.out.print(e);
    	}
    	return user;
    }
}