import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;
/**
* 模糊查询
*/
public class FuzzyQueryTest {
/**
* 根据用户名称模糊查询用户信息
*/
public List<Users> fuzzyQuery(String username){
Connection connection = null;
PreparedStatement preparedStatement = null;
ResultSet resultSet = null;
List<Users> list = new ArrayList<>();
try {
connection = JDBCUtils.getConnection();
preparedStatement = connection.prepareStatement("select * from users where username like ?");
preparedStatement.setString(1,username);
resultSet=preparedStatement.executeQuery();
while(resultSet.next()){
Users users = new Users();
users.setUsername(resultSet.getString("username"));
users.setUserid(resultSet.getInt("userid"));
users.setUserage(resultSet.getInt("userage"));
list.add(users);
}
}catch (Exception e){
e.printStackTrace();
}finally {
JDBCUtils.clossResource(resultSet,preparedStatement,connection);
}
return list;
}
public static void main(String[] args) {
FuzzyQueryTest fuzzyQueryTest = new FuzzyQueryTest();
List<Users> users = fuzzyQueryTest.fuzzyQuery("%g%");
for(Users user1:users){
System.out.println(user1.getUserid()+" "+user1.getUsername()+" "+user1.getUserage());
}
}
}