[Java]JDBC UPDATE하기

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class Jdbc_update {
	private static Connection conn;
	private static Statement stmt;
	private static PreparedStatement pstmt;
	private static ResultSet rs;

	// 자원반납용
	private static void disConnect() {
		if(rs != null) {
			try {
				rs.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		if(stmt != null)
			try {
				stmt.close();
			} catch (Exception e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}

		if(conn != null) {
			try {
				conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		if(pstmt != null) {
			try {
				pstmt.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}

	}

	public static void main(String[] args) {

		String query_update = "UPDATE 테이블명 SET 컬럼명 = '바꿀값' WHERE 컬럼명 = '조건값'";

		try {
			conn = DButil.getconnection();
			stmt = conn.createStatement();

			pstmt = conn.prepareStatement(query_update);
			pstmt.executeUpdate();// 쿼리 실행
			conn.commit();// commit

		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally {
			disConnect();// 자원반납
		}
	}
}

 

 

자바에서 DB에 값을 update하는 방법입니다.

더 좋은 생각 있으신 분은 댓글 남겨주시면 감사하겠습니다~!