《spring整合jdbc的配置》由会员分享,可在线阅读,更多相关《spring整合jdbc的配置(7页珍藏版)》请在金锄头文库上搜索。
1、Spring+jdbcspringContext.xml在src目录下新建一个名为springContext.xml内容如下: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 St
2、ring 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 St
3、ring 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;pub
4、lic 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 ge
5、tuHead() ( 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
6、.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
7、.DataSource;import org.springframework.jdbc.core.JdbcTemplate;import net.gicp.caihaobin.service.UserInfoService;public class UserInfoServiceImpI implements UserInfoService (private JdbcTemplate jdbcTemplate ;public List listUser( int uid)(String sql = select * from userinfo;List list = jdbcTemplate
8、.query(sql, new UserRowMapper();return list;public void setDataSource(DataSource dataSource) (this.jdbcTemplate = new JdbcTemplate(dataSource);在这个实现类中有个 new UserRowMapper()这个类是位于 net.gicp.caihaobin.service.impl 下UserRowMapper.java内容如下:package net.gicp.caihaobin.service.impl;import java.sql.ResultSet
9、;import java.sql.SQLException;import net.gicp.caihaobin.bean.UserInfo;import org.springframework.jdbc.core.RowMapper;public class UserRowMapper implements RowMapper (public Object mapRow(ResultSet rs,int index) throws SQLException (UserInfo user = new UserInfo();user.setuName(rs.getString(uName);ret
10、urn user; 最后,就是测试src 下新建一个 package net.gicp.caihaobin.test在此包下新建一个单元测试:右键 net.gicp.caihaobin.test - New -输入 junit 选择 junit 4 test内容如下:package net.gicp.caihaobin.test;import java.util.Iterator;import java.util.List;import net.gicp.caihaobin.bean.UserInfo;import net.gicp.caihaobin.service.UserInfoServic