在SSH框架下初始化数据

在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>