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

/*
public class DbTest4 {
	public static void main(String[] args) {
		Connection con = null;
		Statement stmt = null;

		try{
			Class.forName("oracle.jdbc.OracleDriver");
			con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "scott", "1111");

			int empno = 10;
			String ename = "임꺽정";
			int sal = 3000;
			String job = "MANAGER";

			String sql =
				"insert into emp(empno, ename, sal, job) "
				+ "values(" + empno + ",'" + ename +
				"', " + sal + ", '" + job + "')";

			stmt = con.createStatement();
			stmt.executeUpdate(sql);
		}
		catch(Exception err){
			err.printStackTrace();
		}
		finally{
			try{
				if(stmt!=null) stmt.close();
				if(con!=null) con.close();
			}
			catch(Exception err){}
		}
	}
}
*/

public class DbTest4 {
	public static void main(String[] args) {
		Connection con = null;
		PreparedStatement stmt = null;

		try{
			Class.forName("oracle.jdbc.OracleDriver");
			con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "scott", "1111");
			int empno = 11;
			String ename = "김유신";
			int sal = 3000;
			String job = "CLERK";

			String sql = "insert into emp(empno, ename, sal, job) values(?,?,?,?)";

			stmt = con.prepareStatement(sql);

			stmt.setInt(1, empno);
			stmt.setString(2, ename);
			stmt.setInt(3, sal);
			stmt.setString(4, job);

			stmt.executeUpdate();
		}
		catch(Exception err){
			err.printStackTrace();
		}
		finally{
			try{
				if(stmt!=null) stmt.close();
				if(con!=null) con.close();
			}
			catch(Exception err){}
		}
	}
}