Spring自带配置方式链接数据库(没有src新建文件,没有c3p0)
2023-09-11 14:19:39 时间
1.配置文件
<?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context" xmlns:jdbc="http://www.springframework.org/schema/jdbc" xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:p="http://www.springframework.org/schema/p" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:aop="http://www.springframework.org/schema/aop" xsi:schemaLocation="http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc-4.3.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.3.xsd http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.3.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.3.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.3.xsd"> <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate"> <property name="dataSource" ref = "dataSource"></property> </bean> <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> <property name="driverClassName"> <value>com.mysql.jdbc.Driver</value> </property> <property name="url"> <value>jdbc:mysql://localhost:3306/alitaobao</value> </property> <property name="username"> <value>root</value> </property> <property name="password"> <value></value> </property> </bean> <bean id = "PersonDaoImp" class = "com.cc8w.dao.imp.PersonDaoImp"> <property name="jdbcTemplate" ref = "jdbcTemplate"></property> </bean> </beans>
- <!-- 对静态资源文件的访问 方案二 (二选一) -->
- <mvc:resources mapping="/images/**" location="/images/" cache-period="31556926" />
- <mvc:resources mapping="/js/**" location="/js/" cache-period="31556926" />
- <mvc:resources mapping="/css/**" location="/css/" cache-period="31556926" />
2.数据类
package com.cc8w.pojo; public class Person { private String names; private String pid; public Person() { } public Person(String names, String pid) { this.names = names; this.pid = pid; } public String getNames() { return names; } public void setNames(String names) { this.names = names; } public String getPid() { return pid; } public void setPid(String pid) { this.pid = pid; } }
3.dao接口
package com.cc8w.dao; import java.util.List; import com.cc8w.pojo.Person; public interface PersonDao { public List<Person> getAllList(); }
4.实现这个dao接口
package com.cc8w.dao.imp; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import org.springframework.jdbc.core.JdbcTemplate; import org.springframework.jdbc.core.RowCallbackHandler; import com.cc8w.dao.PersonDao; import com.cc8w.pojo.Person; public class PersonDaoImp implements PersonDao { private JdbcTemplate jdbcTemplate; public void setJdbcTemplate(JdbcTemplate jdbcTemplate) { this.jdbcTemplate = jdbcTemplate; } @Override public List<Person> getAllList() { String sql = "SELECT * FROM `think_promoter` LIMIT 0 , 30"; final List<Person> personList = new ArrayList<Person>(); jdbcTemplate.query(sql,new RowCallbackHandler(){ @Override public void processRow(ResultSet rs) throws SQLException { Person p = new Person(); p.setNames(rs.getNString("groupName")); p.setPid(rs.getNString("PID")); personList.add(p); } }); return personList; } }
5.测试类
package com.cc8w; import java.util.List; import org.springframework.context.ApplicationContext; import org.springframework.context.support.ClassPathXmlApplicationContext; import com.cc8w.dao.imp.PersonDaoImp; import com.cc8w.pojo.Person; //import com.cc8w.Entity.Person; public class Test01 { public static void main(String[] args) { ApplicationContext context = new ClassPathXmlApplicationContext("applicationContext.xml"); PersonDaoImp p1 = (PersonDaoImp)context.getBean("PersonDaoImp"); List<Person> p = p1.getAllList(); for(Person val:p) { System.out.println(val.getNames()); } } }
6.结果
本次参考文章:http://blog.csdn.net/mypanlong/article/details/46984535
下次实验:有C3P0的配置,链接数据库
<?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:cache="http://www.springframework.org/schema/cache" xmlns:context="http://www.springframework.org/schema/context" xmlns:jdbc="http://www.springframework.org/schema/jdbc" xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:p="http://www.springframework.org/schema/p" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.3.xsd http://www.springframework.org/schema/cache http://www.springframework.org/schema/cache/spring-cache-4.3.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.3.xsd http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc-4.3.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.3.xsd"> <!-- spring MVC 注解驱动 --> <mvc:annotation-driven></mvc:annotation-driven> <!-- 配置自动扫描包 --> <context:component-scan base-package="com.cc8w.control"></context:component-scan> <!-- 配置视图解析器 --> <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver"> <property name="prefix" value="/WEB-INF/view/"></property> <property name="suffix" value=".jsp"></property> </bean> <!-- 引入外部配置文件 Spring 2.5--> <context:property-placeholder location="classpath:jdbc.properties"/> <!-- 引入jdbc配置文件 (通过bean) Spring 2.0--> <bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"> <property name="locations"> <list> <value>classpath:jdbc.properties</value> </list> </property> </bean> <bean id = "dataSource" class = "org.springframework.jdbc.datasource.DriverManagerDataSource"> <property name="driverClassName" value = "${driver}"></property> <property name="url" value="${url}"></property> <property name="username" value="${username}"></property> <property name="password" value="${password}"></property> </bean> <bean id = "jdbcTemplate" class = "org.springframework.jdbc.core.JdbcTemplate"> <property name="dataSource" ref = "dataSource"></property> </bean> <bean id = "PersonDaoImp" class = "com.cc8w.dao.imp.PersonDaoImp"> <property name="jdbcTemplate" ref = "jdbcTemplate"></property> </bean> </beans>
jdbc.properties文件
driver = com.mysql.jdbc.Driver
url = jdbc:mysql://127.0.0.1:3306/alitao
username = root
password =
下次参考:http://www.cnblogs.com/caoyc/p/5630622.html
相关文章
- Spring获取properties文件中的属性
- Spring MVC文件上传
- Spring Boot Java应用代码混淆介绍
- Spring Cloud常用组件介绍
- 挺详细的spring+springmvc+mybatis配置整合|含源代码
- FastJson/spring boot: json输出方法二
- spring mvc:文件上传
- spring: spittr实例 构建简单的web应用
- Spring异常解决 java.lang.NullPointerException,配置spring管理hibernate时出错
- spring 学习2-Spring Configuration in detail
- Spring实战5-基于Spring构建Web应用
- spring学习12 -Spring 框架模块以及面试常见问题注解等
- Spring MVC更多家族成员----文件上传---06
- Spring 自动装配模式之byType
- spring-session源码解读-1
- spring boot配置文件【application.yml】常见问题之一,未添加空格
- spring boot配置druid(德鲁伊)
- spring boot+vue前后端项目的分离(我的第一个前后端分离项目)
- Spring框架学习之第3节
- Spring MVC 学习总结(五)——校验与文件上传
- 【Spring注解驱动开发】如何实现方法、构造器位置的自动装配?我这样回答让面试官很满意!
- 009-Spring Boot 事件监听、监听器配置与方式、spring、Spring boot内置事件
- spring-cloud-sleuth+zipkin追踪服务
- Spring MVC文件上传
- @Value的使用 《Spring源码解析》java笔记