springmvc-netctoss.rar_binarization_netctoss

package cn.tedu.oss.dao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import javax.annotation.Resource; import javax.sql.DataSource; import org.springframework.jdbc.core.JdbcTemplate; import org.springframework.jdbc.core.RowMapper; import org.springframework.stereotype.Repository; import cn.tedu.oss.entity.Admin; @Repository("adminDAO") public class AdminDaoJdbcImpl implements AdminDao{ // @Resource(name="ds") //注入DataSource,name指定注入的bean的id。 // private DataSource ds; @Resource(name="jt") private JdbcTemplate jt; public Admin findByAdminCode(String adminCode) { // Admin admin = null; // Connection conn = null; // PreparedStatement ps = null; // ResultSet rs = null; try { // conn = ds.getConnection(); // String sql = "select * from admin_info1 where admin_code = ?"; // ps = conn.prepareStatement(sql); // ps.setString(1, adminCode); // rs = ps.executeQuery(); // if(rs.next()) { // admin = new Admin(); // admin.setAdminId(rs.getInt("admin_id")); // admin.setAdminCode(rs.getString("admin_code")); // admin.setPassword(rs.getString("password")); // admin.setName(rs.getString("name")); // admin.setTelephone(rs.getString("telephone")); // admin.setEmail(rs.getString("email")); // admin.setEnrolldate(rs.getTimestamp("enrolldate")); String sql = "select * from admin_info1 where admin_code=?"; Object[] params = new Object[]{adminCode}; return jt.queryForObject(sql, params,new AdminRowMapper()); } catch (Exception e) { e.printStackTrace(); throw new RuntimeException("账号不存在！",e); } // finally { /* * jdbc规范要求关闭连接时，连接所创建的statement要自动关闭，statement创建的resultset * 也要自动关闭。 * * 有些连接池的实现，在关闭连接时，并没有关闭statement。所以建议最好依次关闭resuletset, * statement和连接。 */ // if(conn != null) { // try { // conn.close(); // } catch (SQLException e) { // // } // } // } // return admin; } /** * 内部类的创建 * @author Administrator * */ class AdminRowMapper implements RowMapper<Admin> { public Admin mapRow(ResultSet rs, int index) throws SQLException { Admin admin = new Admin(); admin.setAdminId(rs.getInt("admin_id")); admin.setAdminCode(rs.getString("admin_code")); admin.setPassword(rs.getString("password")); admin.setName(rs.getString("name")); admin.setTelephone(rs.getString("telephone")); admin.setEmail(rs.getString("email")); admin.setEnrolldate(rs.getTimestamp("enrolldate")); return admin; } } }