67,538
社区成员
发帖
与我相关
我的任务
分享package com.sxt.css.dao;
import java.sql.Connection;
import java.sql.SQLException;
import org.apache.commons.dbutils.DbUtils;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;
import org.apache.commons.dbutils.handlers.BeanListHandler;
import com.sxt.ccs.entity.User;
public class UserDao {
public User findUser(int userid){
User user=null;
Connection conn=DBUtil.getConn();
QueryRunner qr=new QueryRunner();
String sql="select * from user where user_id=?";
try {
user=qr.query(conn, sql, new BeanHandler(User.class),userid);
} catch (SQLException e) {
e.printStackTrace();
}finally{
try {
DbUtils.close(conn);
} catch (SQLException e) {
e.printStackTrace();
}
}
return user;
}
public static void main(String[] args) {
UserDao ud=new UserDao();
User user=(User)ud.findUser(1);
System.out.println("userName="+user.getUserName());
}
}