Java Spring详解如何配置数据源注解开发以及整合Junit

< dependency >

   < groupId >c3p0</ groupId >

   < artifactId >c3p0</ artifactId >

   < version >0.9.1.2</ version >

</ dependency >

< dependency >

   < groupId >com.alibaba</ groupId >

   < artifactId >druid</ artifactId >

   < version >1.1.10</ version >

</ dependency >

< dependency >

   < groupId >mysql</ groupId >

   < artifactId >mysql-connector-java</ artifactId >

   < version >5.1.32</ version >

</ dependency >

Test

public void testC3P0 ( ) throws Exception {

//创建数据源

ComboPooledDataSource dataSource = new ComboPooledDataSource () ;

//设置数据库连接参数

dataSource.setDriverClass ( "com.mysql.jdbc.Driver" ) ;

dataSource.setJdbcUrl ( "jdbc:mysql ://localhost:3306/test" ) ;

datasource.setUser ( "root" );

dataSource.setPassword ( "root" );

//获得连接对象

Connection connection = dataSource.getConnection ();

system.out.println (connection) ;

@Test

public void testDruid ( ) throws Exception {

//创建数据源

DruidDataSource dataSource = new DruidDatasource () ;

//设置数据库连接参数

dataSource.setDriverclassName ( "com.mysql.jdbc .Driver" ) ;

datasource.setUrl ( "jdbc:mysql : //localhost:3306/test" ) ;

datasource.setUsername ( "root" ) ;

datasource.setPassword ( "root" ) ;

//获得连接对象

connection connection = dataSource.getConnection ( ) ;

System.out.println (connection) ;

)

jdbc .driver=com.mysql.jdbc.Driver

jdbc.url=jdbc :mysql://localhost:3306/test

jdbc.username=root

jdbc. password =root

@Test

//测试手动创建 c3p0 数据源(加载properties配置文件)

public void test3() throws Exception {

     //读取配置文件

     ResourceBundle rb = ResourceBundle.getBundle( "jdbc" );

     String driver = rb.getString( "jdbc.driver" );

     String url = rb.getString( "jdbc.url" );

     String username = rb.getString( "jdbc.username" );

     String password = rb.getString( "jdbc.password" );

     //创建数据源对象  设置连接参数

     ComboPooledDataSource dataSource = new ComboPooledDataSource();

     dataSource.setDriverClass(driver);

     dataSource.setJdbcUrl(url);

     dataSource.setUser(username);

     dataSource.setPassword(password);

     Connection connection = dataSource.getConnection();

     System.out.println(connection);

     connection.close();

}

< bean id = "dataSource" class = "com.mchange.v2.c3p0.ComboPooledDataSource" >

     < property name = "driverClass" value = "com.mysql.jdbc.Driver" />

     < property name = "jdbcUrl" value = "jdbc:mysql://localhost:3306/test" />

     < property name = "user" value = "root" />

     < property name = "password" value = " root" />

</ bean >

ApplicationContext applicationContext = new ClassPathXmlApplicationContext ( "applicationContext.xml" ) ;

DataSource dataSource = ( DataSource)

applicationcontext. getBean ( "dataSource" ) ;

Connection connection = dataSource.getConnection ( ) ;

System.out.println ( connection) ;

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

< bean id = "dataSource" class = "com.mchange.v2.c3p0.ComboPooledDataSource" >

     < property name = "driverclass" value = "${jdbc.driver}" />

     < property name = "jdbcUrl" value = "${jdbc.url}" />

     < property name = "user" value = "${jdbc.username} " />

     < property name = "password" value = "${jdbc.password}" />

</ bean >

< context:property-placeholder location = "xx.properties" />

< property name = " " value = "${key} " />

<!--注解的组件扫描-->

< context:component-scan base-package = "com.longdi " ></ context: component-scan>

/ / @Component ( "userDao" )

@Repository ( "userDao" )

public class UserDaoImpl implements UserDao {

@override

public void save ( ) {

system.out.println ( "save running . . . ..." ) ;

}

// @Component ( "userservice ")

@service ( "userservice" )

public class UserserviceImpl implements UserService {

/*@Autowired

CQualifier ( "userDao")*/

     @Resource (name= "userDao" )

     private UserDao userDao;

     @override

     public void save ( ) {

     userDao.save ( ) ;

}

)

@Repository ( "userDao" )

public class UserDaoImpl implements UserDao {

@value ( "注入普通数据" )

private string str;

@value ( "${jdbc.driver} " )

private string driver;

@override

public void save () {

system.out.println (str) ;

system.out.println (driver) ;

system.out.println ( "save running......" ) ;

)

//  @scope ( "prototype ")

     @Scope ( "singleton" )

public class UserDaoImpl implements UserDao {

//此处省略代码

)

@PostConstruct

public void init () {

system.out.println ( "初始化方法...." );

}

@PreDestroy

public void destroy () {

system.out.println ( "销毁方法....." );

)

@Configuration

@componentScan ( "com.longdi" )

@Import ({DataSourceConfiguration. class })

public class SpringConfiguration {

)

@Propertysource ( "classpath:jdbc.properties" )

public class DataSourceConfiguration {

@value ( "${jdbc.driver}" )

private string driver ;

@value ( "${jdbc.ur1 }" )

private string url;

@value ( "${jdbc.username}" )

private string username ;

@value ( "${jdbc.password]" )

private string password;

Bean (name= "dataSource " )

public DataSource getDataSource () throws PropertyvetoException {

ComboPooledDataSource dataSource = new ComboPooledDataSource ( ) ;

datasource.setDriverclass (driver) ;

datasource.setJdbcUrl (url) ;

datasource.setUser (username ) ;

dataSource.setPassword(password) ;

return dataSource;

Test

public void testAnnoConfiguration ( ) throws Exception {

ApplicationContext applicationContext = new AnnotationConfigApplicationContext (SpringConfiguration. class ) ;

UserService userService = (UserService)applicationContext.getBean ( "userService" );

userService.save () ;

Datasource dataSource = (Datasource)applicationContext.getBean ( "dataSource" ) ;

Connection connection = dataSource.getConnection() ;

System.out.println (connection);

ApplicationContext ac = new ClassPathxmlApplicationContext ( "bean.xml " );

IAccountService as = ac.getBean ( "accountservice" ,IAccountService. class )

< dependency >

   < groupId >org.springframework</ groupId >

   < artifactId >spring-test</ artifactId >

   < version >5.0.5.RELEASE</ version >

</ dependency >

     < dependency >

       < groupId >junit</ groupId >

       < artifactId >junit</ artifactId >

       < version >4.12</ version >

       < scope >test</ scope >

</ dependency >

@RunWith (SpringJUnit4ClassRunner. class )

public class SpringJunitTest {

}

@RunWith (SpringJUnit4ClassRunner. class )

//加载Spring核心配置文件

//@ContextConfiguration("classpath:applicationContext.xml")

//加载Spring核心配置类

@ContextConfiguration (classes = {SpringCofiguration. class })

public class SpringJunitTest {

@RunWith (SpringJUnit4ClassRunner. class )

@ContextConfiguration (classes = {SpringCofiguration. class })

public class SpringJunitTest {

     @Autowired

     private UserService userService;

}

@RunWith (SpringJUnit4ClassRunner. class )

@ContextConfiguration (classes = {SpringCofiguration. class })

public class SpringJunitTest {

     @Autowired

     private UserService userService;

     @Test

     public void test1() throws SQLException {

         userService.save();

     }

}