spring jdbc

增删 改使用 update

查询 使用 query   / queryForObjext

JdbcTemplate 

使用JdbcTemplate可节省大量的冗余代码，因为JdbcTemplate类会自动处理它。

内部类返回对象一个或多个：public RowMapper<Admin_User> rowMapper = new RowMapper<Admin_User>() {public Admin_User mapRow(ResultSet rs, int rowNum)  throws SQLException{Admin_Useradmin =new Admin_User();admin.setUsername(rs.getString("username"));admin.setPassword( rs.getString("password"));admin.setFile(rs.getString("img"));admin.setLogindate(rs.getString("CreatDate"));admin.setLogincount(rs.getInt("LoginCount"));return admin;}};

private JdbcTemplate jdbcTemplate;public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {this.jdbcTemplate = jdbcTemplate;}

/** * 删除用户 */public void deleAdmin_UserDao(String username) {String sql = "DELETE FROM  adminuser WHERE username=?";JdbcTemplate.update(sql, username);}/** * 查询用户 */public Admin_User SeleAdmin_UserDao(String username) {String sql = "SELECT * FROM adminuser WHERE binary username=?";return JdbcTemplate.queryForObject(sql, new Object[]{username},rowMapper);}

xml配置文件：

 <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"><property name="driverClassName" value="com.mysql.jdbc.Driver" /><property name="url" value="jdbc:mysql://localhost:3306/integraimanager" /><property name="username" value="root" /><property name="password" value="123" /></bean><bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate"><property name="dataSource" ref="dataSource"></property></bean><bean id="admin_UserDaoSpringImpl"  class="com.hst.integraimanager.dao.impl.Admin_UserDaoSpringImpl"><property name="jdbcTemplate" ref="jdbcTemplate"> </property></bean>

JdbcDaoSupport 

java代码：只需要继承JdbcDaoSupport即可  不用惊喜

/** * 查询用户 */public Admin_User SeleAdmin_UserDao(String username) {String sql = "SELECT * FROM adminuser WHERE binary username=?";return (Admin_User) getJdbcTemplate().queryForObject(sql, new Object[]{username},rowMapper);}

xml 配置 

<context:property-placeholder location="classpath:jdbc.properties" /><bean id="dataSource"class="org.springframework.jdbc.datasource.DriverManagerDataSource"><property name="driverClassName" value="${jdbc.driverClassName}" /><property name="url" value="${jdbc.url}" /><property name="username" value="${jdbc.username}" /><property name="password" value="${jdbc.password}" /></bean><bean id="admin_UserDaoSpringImpl"class="com.hst.integraimanager.dao.impl.Admin_UserDaoSpringImpl"><property name="dataSource" ref="dataSource"></property></bean>

jdbc.properties文件配置
jdbc.driverClassName=com.mysql.jdbc.Driverjdbc.url=jdbc:mysql://localhost:3306/integraimanagerjdbc.username=rootjdbc.password=123