sring框架的jdbc应用
2024-09-05 01:11:11
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-3.0.xsd ">
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-3.0.xsd ">
<!-- Initialization for data source -->
<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/test"/>
<property name="username" value="root"/>
<property name="password" value="wuxu112411"/>
</bean>
<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/test"/>
<property name="username" value="root"/>
<property name="password" value="wuxu112411"/>
</bean>
<!-- Definition for studentJDBCTemplate bean -->
<bean id="DaoJdbc"
class="com.cn.DaoJdbc">
<property name="dataSource" ref="dataSource" />
</bean>
<bean id="DaoJdbc"
class="com.cn.DaoJdbc">
<property name="dataSource" ref="dataSource" />
</bean>
</beans>
javaDAO层获取以及使用
private DataSource ds;
private JdbcTemplate jdbc;
public DataSource getDs() {
return ds;
}
private JdbcTemplate jdbc;
public DataSource getDs() {
return ds;
}
@Override
public void setDataSource(DataSource ds) {
this.ds = ds;
this.jdbc = new JdbcTemplate(ds);
}
public void setDataSource(DataSource ds) {
this.ds = ds;
this.jdbc = new JdbcTemplate(ds);
}
@Override
public void create(String name, String password) {
String sql = "insert into t_user (username, password) values (?, ?)";
jdbc.update( sql, name, password);
System.out.println("Created Record Name = " + name + " Age = " + password);
}
public void create(String name, String password) {
String sql = "insert into t_user (username, password) values (?, ?)";
jdbc.update( sql, name, password);
System.out.println("Created Record Name = " + name + " Age = " + password);
}
最新文章
- Android 死锁和重入锁
- AR创意分享：儿童涂鸦遇上程序绘图
- HL7 2.6解析转XML(C#版)
- 对象关系映射ORM
- VirtualProvider （VirtualCube）虚拟立方体
- Java Hour 19 List
- 【Unity3D基础教程】给初学者看的Unity教程（七）：在Unity中构建健壮的单例模式（Singleton）
- new tips
- cocos2d-html5 笔记5: 事件
- Node安装与环境配置
- Objective-C中的const ,extern,static
- Tomcat架构（四）
- JavaEE Tutorials (16) - Java消息服务概念
- 极路由器刷机安装ss插件最新教程
- 虚拟机创建流程中neutron代码分析（三）
- 淘宝地址爬取及UI展示
- 深入Eureka/Feign/Hystrix原理学习（1）
- 用cocoapods导入第三方库，找不到对应的文件
- JAVA四则运算字符串解释器
- 论文中“but”与“however”的区别