Search4member-Source

package org.vidar.controller; import org.noear.solon.annotation.Controller; import org.noear.solon.annotation.Inject; import org.noear.solon.annotation.Mapping; import org.noear.solon.annotation.Param; import org.noear.solon.core.handle.ModelAndView; import org.vidar.config.DbManager; import javax.sql.DataSource; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import java.util.List; @Controller public class SearchController { @Inject private DbManager dbManager; @Mapping("/") public ModelAndView search(@Param(defaultValue = "web") String keyword) throws SQLException { List<String> results = new ArrayList<>(); if (keyword != null & !keyword.equals("")) { String sql = "SELECT * FROM member WHERE intro LIKE '%" + keyword + "%';"; DataSource dataSource = dbManager.getDataSource(); Statement statement = dataSource.getConnection().createStatement(); ResultSet resultSet = statement.executeQuery(sql); while (resultSet.next()) { results.add(resultSet.getString("id") + " : " + resultSet.getString("intro") + " : " + resultSet.getString("blog")); } resultSet.close(); statement.close(); } ModelAndView model = new ModelAndView("search.ftl"); model.put("results", results); return model; } }