1 配置spring文件
<bean id="hibernateTemplate" class="org.springframework.orm.hibernate3.HibernateTemplate"><wbr><br><wbr><wbr><property name="sessionFactory" ref="sessionFactory"></property><br><wbr></bean><wbr><br><wbr><bean id="<span style="color:#FF2D12; word-wrap:normal; word-break:normal">jdbcTemplate</span>" class="org.springframework.jdbc.core.JdbcTemplate"><br><wbr><wbr><property name="dataSource" ref="dataSource" /><br><wbr></bean></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
2 在web.xml中加载spring的配置文件
<context-param>
<wbr><wbr><param-name>contextConfigLocation</param-name><br><wbr><wbr><param-value><br><wbr><wbr><wbr>classpath*:/<span style="color:#FF2D12; word-wrap:normal; word-break:normal">spring/applicationContext_*.xml<br></span><wbr><wbr></param-value><br><wbr></context-param></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
3 在servlet中获取名字为jdbcTemplat的bean.
public class UserAuthorizationFilter extends HttpServlet {
private WebApplicationContext wac;
<wbr><wbr><wbr>public void init(){<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr>方法一:wac =WebApplicationContextUti<wbr>ls.getRequiredWebApplicatio<wbr>nContext(</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>this.getServletContext());</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
<wbr><wbr><wbr><wbr><wbr><wbr><wbr>方法二:wac = WebApplicationContextUti<wbr>ls.getWebApplicationContext<wbr>(<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>this.getServletContext());</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
<wbr><wbr><wbr><wbr><wbr><wbr>方法一和方法二得到的结果是一样的。</wbr></wbr></wbr></wbr></wbr></wbr>
<wbr><wbr><wbr><wbr>//wac的类型:org.springframework.web.context.support.XmlWebApplicationContext<wbr></wbr></wbr></wbr></wbr></wbr>
<wbr><wbr><wbr>}</wbr></wbr></wbr>
public void doPost(HttpServletRequest request, HttpServletResponse response)
<wbr><wbr><wbr>throws ServletException, IOException {</wbr></wbr></wbr>
<wbr><wbr><wbr><wbr>JdbcTemplate jdbcTemplate = (JdbcTemplate)wac.getBean("jdbcTemplate");</wbr></wbr></wbr></wbr>
<wbr><wbr><wbr><wbr>String sql="select count(*) from customer where name='liwj' and password='1111111'";</wbr></wbr></wbr></wbr>
<wbr><wbr><wbr><wbr>int num=jdbcTemplate.queryForInt(sql);<br><wbr><wbr><wbr><wbr>if(num==1){<wbr><wbr><wbr><br><wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>