【Spring】Spring连接MySQL数据库

 

Spring连接MySQL数据库

配置pom文件

 

		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<version>5.1.34</version>
		</dependency>

配置属性文件

url=jdbc:mysql://localhost:3306/data?Unicode=true&characterEncoding=UTF-8&allowMultiQueries=true
driverClassName=com.mysql.jdbc.Driver
password=123456
username=root

配置xml文件

<!-- 1.数据库配置 -->
	<bean id="dataSource"
		class="org.springframework.jdbc.datasource.DriverManagerDataSource">
		<property name="driverClassName" value="${driverClassName}"></property>
		<property name="url" value="${url}"></property>
		<property name="password" value="${password}"></property>
		<property name="username" value="${username}"></property>
	</bean>

	<!-- 2.配置JDBC帮助类 -->
	<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
		<property name="dataSource" ref="dataSource"></property>
	</bean>

	<!-- 3.加载资源文件 -->
	<bean id="propertyConfigurer"
		class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
		<property name="locations">
			<list>
				<value>classpath:spring/dbconfig.properties</value>
			</list>
		</property>
	</bean>
	<bean id="demo" class="com.dmeo.jdbc.JDBCTest"></bean>

测试类

import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.springframework.jdbc.core.JdbcTemplate;

public class JDBCTest {
	public JdbcTemplate geJdbcTemplate() {
		String config = "spring/jdbc.xml";
		ApplicationContext ac = new ClassPathXmlApplicationContext(config);
		JdbcTemplate jdbcTemplate = (JdbcTemplate) ac.getBean("jdbcTemplate");
		return jdbcTemplate;
	}
	public static void main(String[] args) {
		String config = "spring/jdbc.xml";
		ApplicationContext ac = new ClassPathXmlApplicationContext(config);
		JDBCTest jdbcTest = (JDBCTest)ac.getBean("demo");
		JdbcTemplate jdbcTemplate = jdbcTest.geJdbcTemplate();
		System.out.println(jdbcTemplate.queryForList("select * from login"));
	}
}

结果