java+spring+mysql配置_用spring的beans配置mysql数据库
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-2.5.xsd">
用一個servlet初始化這個beans,然后用單例模式控制使整個項目用一個bean工廠:
import java.io.BufferedReader;
import java.io.BufferedWriter;
import java.io.IOException;
import java.io.InputStreamReader;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import org.springframework.beans.factory.BeanFactory;
import org.springframework.beans.factory.xml.*;
import org.springframework.core.io.*;
public class InitServlet extends HttpServlet {
public static Resource res = null;
public static BeanFactory factory = null;
public InitServlet() {
super();
}
public void destroy() {
super.destroy(); // Just puts "destroy" string in log
// Put your code here
}
@SuppressWarnings("deprecation")
public void init() throws ServletException {
if(res==null)
res = new ClassPathResource("/com/beans.xml");
if(factory==null)
factory = new XmlBeanFactory(res);
}
}
下面就是mvc模式中的m了,這是我隨便寫的一個測試類:
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import org.springframework.jdbc.datasource.DriverManagerDataSource;
public class DBHome {
public DriverManagerDataSource database = null;
public DBHome() {
}
public DBHome(DriverManagerDataSource database) {
System.out.println("++++++++++++");
this.setDataSource(database);
}
public void setDataSource(DriverManagerDataSource database){ //注意這個必須要寫這個set方法,這個方法起名是有要求的:set+在beans里面database映射到DBHome里面的名字(首字母要變大寫),也就是setDataSource。這樣寫,beans會自動找到這個方法,然后給DriverManagerDataSource database賦值。
this.database = database;
}
public void test(){
Connection conn=null;
try {
conn =database.getConnection();
Statement s =conn.createStatement();
ResultSet res =s.executeQuery("select * from userTable");
while(res.next()){
System.out.println(res.getString(2));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
然后是mvc中的c了,他要用到DBHome類,應該從beans里面取,該怎么取呢?看下面:
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class UserServlet extends HttpServlet {
public DBHome home = (DBHome)InitServlet.factory.getBean("dbHome");//從beans里面取生成的對象。
public UserServlet() {
super();
}
public void destroy() {
super.destroy(); // Just puts "destroy" string in log
// Put your code here
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doPost(request, response);
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
home.test();
}
}
輸出結果:xiaoming
xiaohong
當然沒寫v的部分,在這簡單的寫了一下spring怎么通過beans配置數據庫,通過beans怎么實例化配置在beans里面的類的對象。
分享到:
2012-03-06 15:07
瀏覽 7264
評論
總結
以上是生活随笔為你收集整理的java+spring+mysql配置_用spring的beans配置mysql数据库的全部內容,希望文章能夠幫你解決所遇到的問題。
- 上一篇: mysql持久连接_持久性连接,短连接和
- 下一篇: mysql8.0怎么导入数据_MySQL