今天碰到要在ssh项目中的一个普通类中访问spring容器管理的bean,现在找到一种解决办法,不知道是否是优化的,先记录下来,以免下次又要狂搜索。
还需要在web.xml中增加:
package com.**;
import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.OutputStream;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.SQLException;
import javax.servlet.ServletConfig;
import javax.servlet.ServletContext;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.sql.DataSource;
import oracle.xml.sql.query.OracleXMLQuery;
import org.springframework.context.ApplicationContext;
import org.springframework.web.context.support.WebApplicationContextUtils;
public class XMLQuery extends HttpServlet throws ServletException
{
public void init(ServletConfig config)
{
super.init(config);
System.out.println("Init Success!!!!!!!!!!");
ServletContext context = config.getServletContext();
ApplicationContext ctx = WebApplicationContextUtils.getRequiredWebApplicationContext(context);
DataSource dataSource = (DataSource) ctx.getBean("dataSource");
try
{
Connection conn = dataSource.getConnection();
this.sqlToXML(conn);
} catch (SQLException e)
{
e.printStackTrace();
}
}
public void sqlToXML(Connection conn)
{
try{
OracleXMLQuery query = new OracleXMLQuery(conn, "SELECT user_id,
user_name, user_password FROM sys_user");
query.setRowTag("journal");
String xmlString=query.getXMLString();
OutputStream output=new FileOutputStream(new File("c:/catalog-output.xml"));
PrintWriter printWriter=new PrintWriter(output);
printWriter.print(xmlString);
printWriter.flush();
}catch(IOException e){}
}
}
还需要在web.xml中增加:
<servlet>
<servlet-name>TimerServlet</servlet-name>
<servlet-class>com.hnnd.common.xmlquery.XMLQuery</servlet-class>
<load-on-startup>1</load-on-startup>
</servlet>