在src中创建如下:
在下面创建jsp文件
UserDaoImpl中输入代码:
package com.zhongruan.dao.impl;
import com.zhongruan.dao.IUserDao;
import com.zhongruan.model.User;
import com.zhongruan.util.DBUtil;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
public class UserDaoImpl implements IUserDao {
@Override
public User findUserByUsername(String username) {
Connection connection=null;
PreparedStatement statement=null;
ResultSet resultSet=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.setId(resultSet.getInt(1));
user.setUsername(username);
user.setPassword(resultSet.getString(3));
}
}catch (Exception e){
e.printStackTrace();
}finally {
DBUtil.closeAll(resultSet,statement,connection);
}
return user;
}
}
IUserDao输入代码:
package com.zhongruan.dao;
import com.zhongruan.model.User;
import com.zhongruan.util.DBUtil;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
public interface IUserDao {
User findUserByUsername(String username);
}
在User中输入代码:
package com.zhongruan.model;
public class User {
private int id;
private St