Java JDBC update

package lec12.jdbc.ex01;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
//update
public class JdbcMain02 {

	public static void main(String[] args) {
		//데이터베이스 연결
		Connection conn = null;
		//실행할때 사용하는 클래스
		PreparedStatement pstmt = null;
		//실행 결과 저장
		ResultSet rs = null;
		
		try {
			//java에서 정해 놓은 규칙
			Class.forName("org.mariadb.jdbc.Driver");
			//db 경로
			String url = "";
			//db 사용자
			String user = "";
			//db 비밀번호
			String pass = "";
			
			conn = DriverManager.getConnection(url, user, pass);
			System.out.print("커넥션 연결 : " + conn);
			
			String strProcureRequestNo = "20170103001";
			String orderRequestNo = "20170103001";
			
			String query = " UPDATE procure_procure_request " + 
							" SET order_request_no = " + orderRequestNo +
							" WHERE procure_request_no = " + strProcureRequestNo;
			
			pstmt = conn.prepareStatement(query);
			
			int result = pstmt.executeUpdate();
			System.out.println("업데이트 결과 : "+ result);
			pstmt.close();
			
			query = " SELECT * " +
					" FROM		procure_procure_request " +
					" WHERE		procure_request_no = " + strProcureRequestNo +	
					" ORDER BY  procure_request_no asc ";
			
			pstmt = conn.prepareStatement(query);
			
			rs = pstmt.executeQuery();
			
			ResultSetMetaData rsmd = rs.getMetaData();
			
			while (rs.next() ) {
				for (int i=0; i<rsmd.getColumnCount(); i++) {
					String columnName = rsmd.getColumnName(i+1);
					String value = rs.getString(i+1);
					System.out.println(columnName + " = [" + value + " ] \t");
				}
			}
			
			
		} catch(Exception e) {
			e.printStackTrace();
		}
	}
}