Spring-jdbc

Spring jdbc

 

JdbcTemplate 

 

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

 

内部类返回对象一个或多个：public RowMapper<Admin_User> rowMapper = new RowMapper<Admin_User>() {
				public Admin_User mapRow(ResultSet rs, int rowNum)  throws SQLException{
				Admin_User	admin =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;
			}
		};
						public Admin_User mapRow(ResultSet rs, int rowNum)  throws SQLException{
				Admin_User	admin =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;
			}
		};
		

/**
	 * 删除用户
	 */
	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配置文件：

 

 

 

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.Driver
jdbc.url=jdbc:mysql://localhost:3306/integraimanager
jdbc.username=root
jdbc.password=123