在昨天的基础上实现读取数据库内容显示在网页上结果如下
文件如下
UserDaoImpl.java
package com.zhongruan.dao.impl;
import com.zhongruan.DBUil.DBUtil;
import com.zhongruan.dao.IUserDao;
import com.zhongruan.model.User;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
public class UserDaoImpl implements IUserDao {
public User findUsernameByUsername(String username){
ResultSet resultSet = null;
PreparedStatement statement = null;
Connection connection = null;
User user=null;
try {
connection= DBUtil.getConnection();
String sql = “select * from tb_user where username=?”;
statement=connection.prepareStatement(sql);
statement.setString(1,username);
resultSet=statement.executeQuery();
while (resultSet.next()){
user=new User();
user.setUsername(resultSet.getString(2));
user.setPassword(resultSet.getString(3));
//user.setType(resultSet.getInt(4));
}
} catch(ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}finally {
DBUtil.closeAll(resultSet,statement,connection);
}
return user;
}
@Override
public List<User> fin