一包的功能与关系,写的时候要从后向前写
建包util是工具包DBHelper负责数据库连接
bean是实体类包创建用户实体user
package dao;
import java.sql.Connection;
import java.sql.SQLException;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;
import bean.User;
import util.DBHelper;
/**
* 用户表的数据操作对象
* @author 欣慰
*
*/
public class UserDao {//UserDao出现异常应该抛出给biz
//创建QueryRunner对象getUser方法JDBC DBUtils
QueryRunner runner=new QueryRunner();
public User getUser(String name,String pwd) throws SQLException{
//1调用DBHelper对象获取连接
Connection conn=DBHelper.getConnection();
//2准备执行sql语句
String sql="select * from user where name=? and pwd=? and state=1";
//3调用查询方法,将查询的数据封装成User对象
User user=runner.query(conn,sql, new BeanHandler<User>(User.class),name,pwd);
//4关闭连接对象
DBHelper.close(conn);
//5返回User
return user;
}
public static void main (String[] args) {
User user=null;
try {
user=new UserDao().getUser("super", "1234");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
System.out.println(user);
}
}