spring数据源配置
随风起飞 2015-11-19 12:06:33 两种配置第二种报错,直接上码:
第一种
配置
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
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.xsd">
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<property name="driverClassName" value="com.mysql.jdbc.Driver" />
<property name="url" value="jdbc:mysql://localhost:3306/test" />
<property name="username" value="myapp" />
<property name="password" value="javablog" />
</bean>
<bean id="dao" class="demo.springframwork.datasource.direct.Dao">
<property name="dataSource" ref="dataSource"></property>
</bean>
</beans>
package demo.springframwork.datasource.direct;
import java.sql.Connection;
import java.sql.SQLException;
import org.apache.commons.dbcp.BasicDataSource;
public class Dao {
private BasicDataSource dataSource;
public void setDataSource(BasicDataSource dataSource) {
this.dataSource = dataSource;
}
public Connection getConn() throws SQLException{
return dataSource.getConnection();
}
}
package demo.springframwork.datasource.direct;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import utils.jdbc.User;
public class Application {
public static void main(String[] args) throws SQLException {
ApplicationContext context = new ClassPathXmlApplicationContext(
new String[]{"demo/springframwork/datasource/direct/daos.xml"});
Dao dao = context.getBean("dao",Dao.class);
Connection con = dao.getConn();
Statement stm = con.createStatement();
String sql = null;
sql = "select * from users where user_name='xkr' and password = "+123456;
ResultSet rs = stm.executeQuery(sql);
List<User> users = new ArrayList<User>();
while(rs.next()){
User u = new User();
u.setId(rs.getInt(1));
u.setUserName(rs.getString(2));
u.setPassword(rs.getString(3));
u.setCreateTime(rs.getDate(4));
u.setUpdateTime(rs.getDate(5));
users.add(u);
System.out.println("userId:"+u.getId()
+",userName:"+u.getUserName()
+",password:"+u.getPassword()
+",createTime:"+u.getCreateTime()
+",updateTime:"+u.getUpdateTime());
}
System.out.println(users.size());
}
}
第二种
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
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.xsd">
<bean id="mappings" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="locations" value="demo/springframwork/datasource/properties/jdbc.properties"></property>
</bean>
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<property name="driverClassName" value="${jdbc.driverClassName}"/>
<property name="url" value="${jdbc.url}"/>
<property name="username" value="${jdbc.username}"/>
<property name="password" value="${jdbc.password}"/>
</bean>
<bean id="dao" class="demo.springframwork.datasource.properties.Dao">
<property name="dataSource" ref="dataSource"></property>
</bean>
</beans>
jdbc.properties:
jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/test
jdbc.username=myapp
jdbc.password=javablog
package demo.springframwork.datasource.direct;
import java.sql.Connection;
import java.sql.SQLException;
import org.apache.commons.dbcp.BasicDataSource;
public class Dao {
private BasicDataSource dataSource;
public void setDataSource(BasicDataSource dataSource) {
this.dataSource = dataSource;
}
public Connection getConn() throws SQLException{
return dataSource.getConnection();
}
}
package demo.springframwork.datasource.properties;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import utils.jdbc.User;
public class Application {
public static void main(String[] args) throws SQLException {
ApplicationContext context = new ClassPathXmlApplicationContext(
new String[]{"demo/springframwork/datasource/properties/daos.xml"});
Dao dao = context.getBean("dao",Dao.class);
Connection con = dao.getConn();
Statement stm = con.createStatement();
String sql = null;
sql = "select * from users where user_name='xkr' and password = "+123456;
ResultSet rs = stm.executeQuery(sql);
List<User> users = new ArrayList<User>();
while(rs.next()){
User u = new User();
u.setId(rs.getInt(1));
u.setUserName(rs.getString(2));
u.setPassword(rs.getString(3));
u.setCreateTime(rs.getDate(4));
u.setUpdateTime(rs.getDate(5));
users.add(u);
System.out.println("userId:"+u.getId()
+",userName:"+u.getUserName()
+",password:"+u.getPassword()
+",createTime:"+u.getCreateTime()
+",updateTime:"+u.getUpdateTime());
}
System.out.println(users.size());
}
}
第二种异常:
Exception in thread "main" org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'myapp '@'localhost' (using password: YES))
at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at demo.springframwork.datasource.properties.Dao.getConn(Dao.java:16)
at demo.springframwork.datasource.properties.Application.main(Application.java:20)
Caused by: java.sql.SQLException: Access denied for user 'myapp '@'localhost' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:959)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3870)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3806)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:871)
at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1686)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1207)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2254)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2285)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2084)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:795)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:400)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:327)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)
at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
... 4 more
以上~