servlet如何依赖注入JDBC进行查询等操作,数据库是ORACLE,请大侠帮帮忙,谢谢

来源:百度知道 编辑:UC知道 时间:2024/07/07 20:58:10
spring的配置文件里面已经连上ORACLE数据库
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType(CONTENT_TYPE);
response.addHeader("Expires", "0");
response.addHeader("Cache-Control", "no-store,must-revalidate");
response.addHeader("Cache-Control", "post-check=0,pre-check=0");
response.addHeader("Pragma", "no-cache");
PrintWriter out = response.getWriter();
StringBuffer sql=new StringBuffer();
String hzsfzh=request.getParameter("hzsfzh");
sql.append(" SELECT F_GETD401_04('"+hzsfzh+"') CSRQ FROM DUAL");
List list =jdbc.queryForList(sql.toString());
String returns=list.get(0).toString();
out.write(returns);
out.close();
}

private DBManager jdbc;
public static void setJdbc(DBManager jdbc){
this.jdbc = jdbc;
}

<bean class="org.dylan.TestServlet">
<property name="jdbc" ref="dbManager"/>
</bean>

没听说过赖注入JDBC,只知道赖注入的SPRING,