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

评论