jsp+servlet实现搜索框

这是搜索框的html代码

 <form action="/pre/search" method="post">
            <div class="indexSearch">
                <input type="text" placeholder="请输入帖子名" name="partname"/>
                <input type="submit" value="搜索"/>
            </div>
            </form>

搜索其实是sql的模糊查询功能

@Override
    public List<Apost> findByPartName(String partName) {
   
        List<Apost> aposts = new ArrayList<>();
        try{
   
            Connection conn = MySqlDbUtil.getConnection();
           String sql = "SELECT * FROM apost where ap