1、在类目录
com.hl.resources/
下配置一个文件:applicationContext-jdbcTemplate.xml
<?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-2.5.xsd">
<bean id="springJdbcTemplate" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="com.mysql.jdbc.Driver">
</property>
<property name="url"
value="jdbc:mysql://localhost:3306/githubliaoliaoprojectmysql">
</property>
<property name="username" value="root"></property>
<property name="password" value="root"></property>
</bean>
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate" abstract="false"
lazy-init="false" autowire="default" dependency-check="default">
<property name="dataSource">
<ref bean="springJdbcTemplate" />
</property>
</bean>
</beans>
2、定义一个类:
JdbcTemplateConnectMySQL
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.springframework.jdbc.core.JdbcTemplate;
public class JdbcTemplateConnectMySQL {
/**
* 寻找上下文.xml文件的3个路径:
* 1:类路径ClassPathXmlApplicationContext;
* 2:(极少用)FileSystemXmlApplicationContext:利用文件系统中的XMl文件来载入Bean
* 3: (极少用)XmlWebApplicationContext:从Web系统中的XML文件来载入Bean定义的信息
* */
public static JdbcTemplate getJdbcTemplate(){
ApplicationContext ctx = new ClassPathXmlApplicationContext("com/hl/resources/applicationContext-jdbcTemplate.xml");
JdbcTemplate jdbcTemp = (JdbcTemplate) ctx.getBean("jdbcTemplate");
return jdbcTemp;
}
}
3、定义一个测试方法:
@Test
public void jdbcTemplate(){
JdbcTemplate jdbcTemp = JdbcTemplateConnectMySQL.getJdbcTemplate();
List<Map<String, Object>> lists = jdbcTemp.queryForList("select * from userInfo");
for(Map<String, Object> map : lists){
System.out.println("------");
System.out.println((String)map.get("user")+(String)map.get("name"));
}
}