[JAVA] JDBC 성적문제 (3) (이름검색/삭제)

🔒 이름 검색 코드 작성

@Override
	public List<ScoreDTO> listScroe(String name) {
		List<ScoreDTO> list = new ArrayList<>();
		Statement stmt = null;
		ResultSet rs = null;
		String sql;
		
		try {
			
			sql = "SELECT hak, name, TO_CHAR(birth, 'YYYY-MM-DD') birth, "
					+ " kor, eng, mat, (kor+eng+mat) tot, (kor+eng+mat)/3 ave "
					+ " FROM score "
					+ " WHERE INSTR(name, '" + name + "') > 0 ";
			//" WHERE name LIKE '%' || '" + name + "' || '%' ";
			
			stmt = conn.createStatement();
			rs = stmt.executeQuery(sql);
			
			while(rs.next()) {
				ScoreDTO dto = new ScoreDTO();
				
				dto.setHak(rs.getString("hak"));
				dto.setName(rs.getString("name"));
				dto.setBirth(rs.getString("birth"));
				dto.setKor(rs.getInt("kor"));
				dto.setEng(rs.getInt("eng"));
				dto.setMat(rs.getInt("mat"));
				dto.setTot(rs.getInt("tot"));
				dto.setAve(rs.getInt("ave"));
				
				list.add(dto);
				
			}
			
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			if(rs != null) {
				try {
					rs.close();
				} catch (Exception e2) {
				}
			}
			
			if(stmt != null) {
				try {
					stmt.close();
				} catch (Exception e2) {
				}
			}
		}
		return list;
	}
 
}

🔒 데이터 삭제 코드

@Override
	public int deleteScore(String hak) throws SQLException {
		int result = 0;
		Statement stmt = null;
		String sql;
		
		try {
			
			sql = "DELETE FROM score WHERE hak = '" + hak + "'";
			stmt = conn.createStatement();
			
			result = stmt.executeUpdate(sql);
			
 
			
		} catch (SQLException e) {
			e.printStackTrace();
			
			throw e;
		} finally {
			if(stmt != null) {
				try {
					stmt.close();
				} catch (Exception e2) {
				}
			}
			
		}
		
		
		return result;
	}