spring + jdbc

Eclipse 新建Java项目

引入一些包，

其中org.springframework开头的是spring框架中的库文件

cglib-nodep-2.2.jar , commons-logging-1.1.1.jar 是依赖文件

sqljdbc4.jar 和 sqlitejdbc-v056.jar 是数据库驱动

在Eclipse中将这些库加入到 build path 中

db/config.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
     xmlns:context="http://www.springframework.org/schema/context"
     xsi:schemaLocation="http://www.springframework.org/schema/beans
         http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
         http://www.springframework.org/schema/context
         http://www.springframework.org/schema/context/spring-context-3.0.xsd">


           
  <context:annotation-config/>
  <context:property-placeholder location="classpath:/db/jdbc.properties"/>

  <bean class="db.AppConfig"/>
 
    <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
        <property name="dataSource" ref="dataSource"></property>
    </bean>

  <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
      <property name="url" value="${jdbc.url}"/>
      <property name="username" value="${jdbc.username}"/>
      <property name="password" value="${jdbc.password}"/>
  </bean>
</beans>

db/jdbc.properties

jdbc.url=jdbc:sqlserver://192.168.1.8;databaseName=test_db;
jdbc.username=sa
jdbc.password=

db/Main.java

package db;

import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

public class Main {

    /**
     * @param args
     */
    public static void main(String[] args) {
        
        ApplicationContext ctx = new ClassPathXmlApplicationContext("classpath:/db/config.xml");
        MyService myService = ctx.getBean(MyService.class);
        myService.doStuff();


    }

}

db/AppConfig.java

package db;

import javax.sql.DataSource;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.jdbc.core.JdbcTemplate;

@Configuration
public class AppConfig {
    
    @Bean
    public MyService myService() {
        return new MyServiceImpl();
    }
    

}

db/MyService.java

package db;

public interface MyService {
    
    public void doStuff();

}

db/MyServiceImpl.java

package db;

import javax.annotation.Resource;
import javax.sql.DataSource;
import org.springframework.jdbc.core.JdbcTemplate;

public class MyServiceImpl implements MyService{
    
    
    @Resource  
    private JdbcTemplate jdbcTemplate;
    
    @Resource  
    private DataSource dataSource;  
    
    
    public DataSource getDataSource() {  
        return this.dataSource;  
    }  
    
    
    public void doStuff(){
        System.out.println("hello");
        
        String sql = "select count(*) from company";
        int count = jdbcTemplate.queryForInt(sql);
        System.out.println(count);
        
    }
}