Spring 与hibernate 整合，测试数据连接

package com.atguigu.spring.hibernate.entities;

public class Account {
	 private Integer id;
	 private String username;
	 private Integer balance;
	public Integer getId() {
		return id;
	}
	public void setId(Integer id) {
		this.id = id;
	}
	public String getUsername() {
		return username;
	}
	public void setUsername(String username) {
		this.username = username;
	}
	public Integer getBalance() {
		return balance;
	}
	public void setBalance(Integer balance) {
		this.balance = balance;
	}
	 
}

package com.atguigu.spring.hibernate.entities;

public class Book {
	private Integer id;
	private String bookname;
	private String isbn;
	private int price;
	private int stock;

	public Integer getId() {
		return id;
	}

	public void setId(Integer id) {
		this.id = id;
	}

	public String getBookname() {
		return bookname;
	}

	public void setBookname(String bookname) {
		this.bookname = bookname;
	}

	public String getIsbn() {
		return isbn;
	}

	public void setIsbn(String isbn) {
		this.isbn = isbn;
	}

	public int getPrice() {
		return price;
	}

	public void setPrice(int price) {
		this.price = price;
	}

	public int getStock() {
		return stock;
	}

	public void setStock(int stock) {
		this.stock = stock;
	}

}

<?xml version="1.0"?>

package com.atguigu.spring.hibernate.test;



import java.sql.SQLException;

import javax.sql.DataSource;

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

public class SpringHibernateTest {
	private ApplicationContext ctx=null;
	{
		ctx =new ClassPathXmlApplicationContext("applicationContext.xml");
	}

	@Test
	public void testDataSource() throws SQLException  {
		DataSource dataSource=ctx.getBean(DataSource.class);
		System.out.println(dataSource.getConnection());
	}

}

<?xml version="1.0" encoding="UTF-8"?>
<?XML:NAMESPACE PREFIX = "[default] http://www.springframework.org/schema/beans" NS = "http://www.springframework.org/schema/beans" />

    <?xml:namespace prefix = "context" />

jdbc.user=root
jdbc.password=21323
jdbc.driverClass=com.mysql.jdbc.Driver
jdbc.jdbcUrl=jdbc:mysql:///test1

jdbc.initialPoolSize=5
jdbc.maxPoolSize=10
#...

<?xml version="1.0" encoding="UTF-8"?>

org.hibernate.dialect.MySQL5InnoDBDialecttruetrueupdate

转载于:https://www.cnblogs.com/xiaofeng01/p/7073336.html