JDBC封装
DAO
public class tbuserDAO {
static Connection connection=null;
PreparedStatement preparedStatement=null;
ResultSet resultSet =null;
static {
try{
connection= DBUtil.getConnection(DBUtil.qudong,DBUtil.url);
}
catch (Exception e)
{ e.printStackTrace();
}
}
public List<Tb_user> finAll(){
List<Tb_user> users=new ArrayList<>();
//1.加载驱动
try {
connection= DBUtil.getConnection(DBUtil.qudong,DBUtil.url);
//3.写sql
String sql="select * from tb_user";
//4.得到statement对象
preparedStatement=connection.prepareStatement(sql);
//5.执行sql
resultSet=preparedStatement.executeQuery();
//6.处理结果集
while(resultSet.next()){
Tb_user user=new Tb_user();
user.setId(resultSet.getInt(1));
user.setUsername(resultSet.getString(2));
user.setPassword(result