Update

 

 

main

public class mainClass {

	public static void main(String[] args) {
		DBConnection.initConnection();

		UpdateTest ut = new UpdateTest();
		
		String id = "abc";
		int age = 23;
		
		boolean b = ut.Update(id, age);
		
		if (b == true) {
			System.out.println("정상적으로 수정되었습니다");
		}
	}
}

UpdateTest

public class UpdateTest {
	
	public boolean Update(String id, int age) {	//찾아야되는 id, 바꿀 데이터age
		
		String sql = " UPDATE USERTEST "		//Query문
					+ " SET AGE = " + age + " "
					+ " WHERE ID = '" + id + "' ";
		
		System.out.println("sql : " + sql);
		
		Connection conn = DBConnection.getConnection();
		Statement stmt = null;
		
		int count = 0;
		try {
			stmt = conn.createStatement();	//현재 상태를 가져옴
			
			count = stmt.executeUpdate(sql);	//쿼리문이 sql로 들어가고 결과가 count로 나옴
			
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			DBClose.close(stmt, conn, null);
		}
		
		return count > 0 ? true: false;	//삼항연산자로 크면 true;
	}
}