<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.Connection"%>
<%@ page language="java" contentType="text/html; charset=euc-kr"
pageEncoding="euc-kr"%>








<%
request.setCharacterEncoding("euc-kr");
String s_id = request.getParameter("s_id");
String s_name = request.getParameter("s_name");
String s_pw = request.getParameter("s_pw");
String s_age = request.getParameter("s_age");
String s_addr = request.getParameter("s_addr");
String s_extension = request.getParameter("s_extension");
String s_dept = request.getParameter("s_dept");

String sql = "insert into tblSawon(no, id, name, pass, age, addr, extension, dept) values(seq_no.nextVal, '"
+ s_id
+ "', '"
+ s_name
+ "','"
+ s_pw
+ "',"
+ s_age
+ ", '"
+ s_addr
+ "','"
+ s_extension
+ "','"
+ s_dept
+ "')";
Connection con = null;
Statement stmt = null;
String url = "jdbc:oracle:thin:@localhost:1521:xe";
String id = "test", pw = "test";

try {
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection(url, id, pw);
stmt = con.createStatement();
stmt.executeUpdate(sql);
%>

직원 정보가 잘 추가되었습니다.