我再写个DAO类,查询语句是这样的String sql="select user-info.*,buyer-in.*from user-info a left outer join buyer-in b on user-info.buyerid=buyer-in.buyerid where a.Aname=?";
我想知道接下来怎么写,我怎么返回结果呢
...全文
14012打赏收藏
本人新手,问个问题求帮助
我再写个DAO类,查询语句是这样的String sql="select user-info.*,buyer-in.*from user-info a left outer join buyer-in b on user-info.buyerid=buyer-in.buyerid where a.Aname=?"; 我想知道接下来怎么写,我怎么返回结果呢
public class UserInfoDaoImpl implements UserInfoDao {
private SessionFactory sessionFactory;
private ResultSet rs;
public UserInfo queryNumber(String name) {
// TODO Auto-generated method stub
String sql="select user-info.*,buyer-in.*from user-info a left outer join buyer-in b on user-info.buyerid=buyer-in.buyerid where a.Aname=?";
SQLQuery query = sessionFactory.getCurrentSession().createSQLQuery(sql);
query.setString(0, name);
query.addEntity(UserInfo.class);
UserInfo a =(UserInfo)query.uniqueResult();
return a;
}