【Spring六】JDBC编程之XML配置 - 数据库编程

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()); } }

【Spring六】JDBC编程之XML配置(二)