整合的上次项目,具体在这里
这次项目整合所用的项目为上个项目,只在spring中做了修改,运用了jdbcTemplate
spring配置文件
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="username" value="root"></property>
<property name="password" value="密码"></property>
<property name="url" value="jdbc:mysql://localhost:3306/newtest"></property>
<property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
</bean>
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
<property name="dataSource" ref="dataSource"></property>
</bean>
接下来进行测试
jdbcTemplate 的 query方法
RowMapper<T>() 和 ResultSetExtractor<T>()两种方法回调
//用JdbcTemplate进行查询 回调的方法是RowMapper<UserBean>()
public static void test2() {
ApplicationContext context =
new ClassPathXmlApplicationContext("test.xml");
JdbcTemplate jdbcTemplate = (JdbcTemplate) context.getBean("jdbcTemplate");
String sql = "select * from userbean where uid=1";
UserBean user = new UserBean();
//需要进行强转
UserBean o = (UserBean) jdbcTemplate.query(sql,new RowMapper<UserBean>() {
@Override
public UserBean mapRow(ResultSet rs, int index) throws SQLException {
// TODO Auto-generated method stub
user.setUid(rs.getInt("uid"));
user.setName(rs.getString("name"));
user.setPwd(rs.getString("pwd"));
return user;
}
//因为返回的是数组所以需要获取一条数据
}).get(0);
System.out.println("test2"+o);
}
//用JdbcTemplate进行查询 回调的方法是ResultSetExtractor<UserBean>()
public static void test3() {
ApplicationContext context =
new ClassPathXmlApplicationContext("test.xml");
JdbcTemplate jdbcTemplate = (JdbcTemplate) context.getBean("jdbcTemplate");
String sql = "select * from userbean where uid=2";
UserBean user = new UserBean();
//用Object时 实体类中需要有toString方法
Object o = jdbcTemplate.query(sql,new ResultSetExtractor<UserBean>() {
@Override
public UserBean extractData(ResultSet rs) throws SQLException, DataAccessException {
while(rs.next()) {
user.setUid(rs.getInt("uid"));
user.setName(rs.getString("name"));
user.setPwd(rs.getString("pwd"));
}
return user;
}
});
System.out.println("test3"+o);
}
//用JdbcTemplate进行查询 回调的方法是ResultSetExtractor<UserBean>() 返回的值是Object
public static void test4() {
ApplicationContext context =
new ClassPathXmlApplicationContext("test.xml");
JdbcTemplate jdbcTemplate = (JdbcTemplate) context.getBean("jdbcTemplate");
String sql = "select * from userbean where uid=2";
UserBean user = new UserBean();
Object o = jdbcTemplate.query(sql,new RowMapper<UserBean>() {
@Override
public UserBean mapRow(ResultSet rs, int index) throws SQLException {
// TODO Auto-generated method stub
user.setUid(rs.getInt("uid"));
user.setName(rs.getString("name"));
user.setPwd(rs.getString("pwd"));
return user;
}
});
System.out.println("test4"+o);
}