DataSource dataSource;
public DataSource getDataSource() {
return dataSource ; }
public
void setDataSource(DataSource dataSource) {
this.dataSource = dataSource; }
public ItHeimaTemplate(){}
public ItHeimaTemplate(DataSource dataSource){
this.dataSource = dataSource; } /** * 实现插入数据 */
public
void insert(String sql){
try { Connection conn =
this.dataSource .getConnection(); Statement statement = conn.createStatement(); statement.executeUpdate(sql); }
catch (Exception e) { } } } ---------------------------------------------------
public
class ClassesDaoImpl4
extends ItHeimaTemplate{
public ClassesDaoImpl4(DataSource dataSource){
super(dataSource); }
public
void insert(){
this.insert("insert into classes(cname,description) values('a','a')"); } } ===================================================
public
class DataSourceTest { @Test
public
void testDataSource(){ ApplicationContext context =
new ClassPathXmlApplicationContext("cn/itheima03/spring/jdbc/applicationContext.xml" ); DataSource dataSource = (DataSource)context.getBean("dataSource" ); System.
out.println(dataSource); } }
=================================================== /** * 查询时，需要写一个类实现RowMapper */
public
class ClassesRowMapper
implements RowMapper{
@Override
public Object mapRow(ResultSet rs,
int rowNum)
throws SQLException { Classes classes =
new Classes(); classes.setCid(rs.getLong( "cid")); classes.setCname(rs.getString( "cname")); classes.setDescription(rs.getString( "description"));
return classes; }
}
===================================================
public
class ClassesDaoTest { @Test
public
void testSaveClasses(){ ApplicationContext context =
new ClassPathXmlApplicationContext("cn/itheima03/spring/jdbc/applicationContext.xml" ); ClassesDao classesDao = (ClassesDao)context.getBean("classesDao3" ); classesDao.saveClasses(); } @Test
public
void testSaveClasses4(){ ApplicationContext context =
new ClassPathXmlApplicationContext("cn/itheima03/spring/jdbc/applicationContext.xml" ); ClassesDaoImpl4 classesDao = (ClassesDaoImpl4)context.getBean("classesDao4" ); classesDao.insert(); } /** * 测试查询 */ @Test
public
void testGetClasses(){ ApplicationContext context =
new ClassPathXmlApplicationContext("cn/itheima03/spring/jdbc/applicationContext.xml" ); ClassesDao classesDao = (ClassesDao)context.getBean("classesDao" ); System.
out.println(classesDao.getClasses().size()); } }
|