spring整合jdbc的配置

Spring+jdbcspringContext.xml在src目录下新建一个名为springContext.xml内容如下：bean id =txManagerclass = org.springframework.jdbc.datasource.DataSourceTransactionManager src 目录下新建一个 package： net.gicp.caihaobin.bean在此包下新建 UserInfo.java内容如下：package net.gicp.caihaobin.bean;public class UserInfo privateint uidprivateStringuName ;privateStringuPasswordprivateStringuSex ;privateStringuQue1 ;privateStringuAns1 ;privateStringuQue2 ;privateStringuAns2 ;privateStringuHead ;privateStringuMessagepublicUserInfo() publicint 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(Stri ng uHead) this . uHead = uHead;public String getuMessage() return uMessage ;public void setuMessage(Stri ng uMessage) this . uMessage = uMessage;src 目录下新建一个 package： net.gicp.caihaobin.service 在此包下新建一个接口：UserInfoService内容如下：packagen et.gicp.caihaob in. service;import java.util.List;public in terface UserI nfoService /*查岀用户* param userinfo*/public List_listUser(int uid);src 目录下新建一个 package： net.gicp.caihaobin.service.impl (这里为实现类) 在此包下新建一个class UserlnfoServicelmpI内容如下：packagen et.gicp.caihaob in. service.impl;import java.util.List;import javax.sql.DataSource;importorg.spri ngframework.jdbc.core.JdbcTemplate;importn et.gicp.caihaob in. service.Userl nfoService;public class UserI nfoServicelmplimpleme ntsUserI nfoService private JdbcTemplate jdbcTemplate ;public List listUser(int uid)Stri ng sql =select * from user infoList 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 下UserRowMapper.java内容如下：package n et.gicp.caihaob in. service.impl;import java.sql.ResultSet;import java.sql.SQLExcepti on;import n et.gicp.caihaob in .bea n. UserI nfo;import org.spri ngframework.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); return 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.UserInfoService;import org.junit.BeforeClass;import org.junit.Test;import org.springframework.context.ApplicationContext;importorg.springframework.context.support.ClassPathXmlApplicationContext;public class SpringTest private static UserInfoService userInfo;BeforeClasspublic static void setUpBeforeClass() throws Exception trynewApplicationContext ctxClassPathXmlApplicationContext(springContext.xml);userInfo = (UserInfoService)ctx.getBean(userInfoService);catch(Exception e) e.printStackTrace();Testpublic void doTest()tryList list = userInfo.listUser(); Iterator iter = list.iterator(); while(iter.hasNext()UserInfo user = (UserInfo)iter.next();System.out.println(user.getuName(); catch (Exception e) e.printStackTrace();这样就输出了 userinfo 这个表中的所有用户名表结构如下：mysql desc userinfo;+-| Field+| Type | Null+| Key | Default | Extra|+-+| uid| int(11) | NO| PRI | NULL | auto_increment | uName| varchar(50) | NO| | NULL | uPassword | varchar(50) | NO| | NULL | uSex| varchar(50) | NO| | NULL | uQue1| varchar(50) | NO| | NULL | uAns1| varchar(50) | NO| | NULL | uQue2| varchar(50) | NO| | NULL | uAns2| varchar(50) | NO| | NULL | uHead| varchar(50) | NO| | NULL | uMessage| varchar(50) | NO| | NULL |