Spring+jdbc
l
在src目录下新建一个名为l
内容如下：
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="/schema/beans"
xmlns:xsi="/2001/XMLSchema-instance"
xmlns:context="/schema/context"
xmlns:tx="/schema/tx"
xsi:schemaLocation="/schema/beans
/schema/beans/spring-beans-3.0.xsd
/schema/context
/schema/context/spring-context-3.0.xsd
/schema/tx /schema/tx/spring-tx-3.0.xsd">
<bean id="dataSource" class="org.apachemons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName" value="sql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://localhost:3306/fl" />
<property name="username" value="root"/>
<property name="password" value="P@ssw0rd"/>
<property name="initialSize" value="1" />
<property name="maxActive" value="500"/>
<property name="maxIdle" value="2" />
<property name="minIdle" value="1" />
</bean>
<bean id="txManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"/>
</bean>
<tx:annotation-driven transaction-manager="txManager"/>
<bean id="userInfoService" class="net.gicp.caihaobin.service.impl.UserInfoServiceImpl">
<property jdbctemplate是什么name="dataSource" ref="dataSource"></property>
</bean>
</beans>
src目录下新建一个package：net.gicp.caihaobin.bean
在此包下新建UserInfo.java
内容如下：
package net.gicp.caihaobin.bean;
public class UserInfo {
private int uid;
private String uName;
private String uPassword;
private String uSex;
private String uQue1;
private String uAns1;
private String uQue2;
private String uAns2;
private String uHead;
private String uMessage;
public UserInfo() {}
public int getUid() {
return uid;
}
public void setUid(int uid) {
this.uid = uid;
}
public String getuName() {
return uName;
}
public void setuName(String uName) {
this.uName = uName;
}
public String getuPassword() {
return uPassword;
}
public void setuPassword(String uPassword) {
this.uPassword = uPassword;
}
public String getuSex() {
return uSex;
}
public void setuSex(String uSex) {
this.uSex = uSex;
}
public String getuQue1() {
return uQue1;
}
public void setuQue1(String uQue1) {
this.uQue1 = uQue1;
}
public String getuAns1() {
return uAns1;
}
public void setuAns1(String uAns1) {
this.uAns1 = uAns1;
}
public String getuQue2() {
return uQue2;
}
public void setuQue2(String uQue2) {
this.uQue2 = uQue2;
}
public String getuAns2() {
return uAns2;
}
public void setuAns2(String uAns2) {
this.uAns2 = uAns2;
}
public String getuHead() {
return uHead;
}
public void setuHead(String uHead) {
this.uHead = uHead;
}
public String getuMessage() {
return uMessage;
}
public void setuMessage(String uMessage) {
this.uMessage = uMessage;
}
}
src目录下新建一个package：net.gicp.caihaobin.service
在此包下新建一个接口：UserInfoService
内容如下：
package net.gicp.caihaobin.service;
import java.util.List;
public interface UserInfoService {
/**
* 查出用户
* @param userinfo
*/
public List listUser(int uid);
}
src目录下新建一个package：net.gicp.caihaobin.service.impl（这里为实现类）
在此包下新建一个class：UserInfoServiceImpl
内容如下：
package net.gicp.caihaobin.service.impl;
import java.util.List;
import javax.sql.DataSource;
import org.JdbcTemplate;
import net.gicp.caihaobin.service.UserInfoService;
public class UserInfoServiceImpl implements UserInfoService {
private JdbcTemplate jdbcTemplate;
public List listUser(int uid){
String sql = "select * from userinfo";
List list = jdbcTemplate.query(sql,new UserRowMapper());
return list;
}
public void setDataSource(DataSource dataSource) {
this.jdbcTemplate = new JdbcTemplate(dataSource);
}
}
在这个实现类中有个new UserRowMapper()
这个类是位于net.gicp.caihaobin.service.impl下
版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。
发表评论