Spring 连接JDBC

连接JDBC

首先导入驱动

配置db.properties

//java代码的形式读取数据看的数据

public class Appliction {

public DruidDataSource ds;

 

@Test

public void test() {

ds=new DruidDataSource();

ds.setDriverClassName("com.mysql.jdbc.Driver");

ds.setUrl("jdbc:mysql://localhost:3306/Spring");

ds.setUsername("root");

ds.setPassword("wangqiang");

ds.setInitialSize(2);

try {

Connection con= ds.getConnection();

PreparedStatement state=con.prepareStatement("select id,name,age from springdata");

ResultSet res=state.executeQuery();

while(res.next()) {

System.out.println(res.getInt("id"));

System.out.println(res.getString("name"));

System.out.println(res.getInt("age"));

}

} catch (SQLException e) {

e.printStackTrace();

}

}

}

//spring的形式之jdbc 

首先导入jar包，spring-jdbc-5.1.2.RELEASE.jar

<!-- Spring-JDBC -->

<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">

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

<property name="url" value="jdbc:mysql://localhost:3306/Spring"/>

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

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

</bean>

 

1⃣️导入jar包 commons-pool-1.6.jar️  commons-dbcp-1.4.jar

2⃣️ 配置bean文件

<!-- dbcp -->

<bean id="BasicDataSource" 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/Spring"/>

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

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

</bean> 

property-placeholder配置：

1⃣️引入约束--或者命名空间content

http://www.springframework.org/schema/context 

http://www.springframework.org/schema/context/spring-context-4.3.xsd

2⃣导入配置文件

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

3⃣️使用${}获取值

<!-- dbcp -->

<bean id="BasicDataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">         

   <property name="driverClassName" value="${driver}"/> 

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

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

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

</bean> 

源码百度云盘自取：链接:https://pan.baidu.com/s/1ubywaQNSCaJnheCr7_8Rug  密码:su1f