在SSH框架下初始化数据:
1.创建Servlet。代码如下:
import java.io.IOException;
import java.util.List;
import java.util.Map;
import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.springframework.jdbc.core.JdbcTemplate;
public class InitServlet extends HttpServlet {
private static final long serialVersionUID = 6689290573685970863L;
private ApplicationContext factory = new ClassPathXmlApplicationContext("applicationContext.xml");
private JdbcTemplate jdbcTemplate = (JdbcTemplate) factory.getBean("jdbcTemplate");
protected void service(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
}
public void init(ServletConfig config) throws ServletException {
loadKeyValue();
}
private void loadKeyValue() {
String sql = " select secondtype, secondtypeValue from pim_contact_item";
List<?> codes = jdbcTemplate.queryForList(sql);
for (int i=0; i<codes.size(); i++) {
Map<?, ?> code = (Map<?, ?>) codes.get(i);
ContactMap.itemMap.put(code.get("secondtype").toString(), code.get("secondtypeValue").toString());
}
}
}
2.创建Map保存数据
import java.util.HashMap;
import java.util.Map;
public class ContactMap {
public static Map<String, String> itemMap = new HashMap<String, String>();
public static Map<String, String> getItemMap() {
return itemMap;
}
public static void setItemMap(Map<String, String> itemMap) {
ContactMap.itemMap = itemMap;
}
}
3.web.xml中配置
<servlet>
<servlet-name>initServlet</servlet-name>
<servlet-class>
com.xxx.xxxx.InitServlet
</servlet-class>
<load-on-startup>3</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>initServlet</servlet-name>
<url-pattern>/initServlet</url-pattern>
</servlet-mapping>