<%@ page contentType="text/html;charset=euc-kr" import="java.sql.* " %>
<% request.setCharacterEncoding("euc-kr"); %>
<html>
<head>
</head>
<body>
<form action="menuInsertDo.jsp" method="post" name="menu">
menu name : <input name="mname" type="text"> <br>
price : <input name="price" type="text"> <br>
<input name="send" type="submit" value="입력">
</form>
</BODY>
</HTML>
-------------------------------------------------------------------------------------------------------
<%@ page contentType="text/html;charset=euc-kr" import="java.sql.*" %>
<% request.setCharacterEncoding("euc-kr"); %>
<%
// 데이터베이스 연결관련 변수 선언
Connection conn = null;
PreparedStatement pstmt = null;
Integer rc =0;
// 데이터베이스 연결관련정보를 문자열로 선언
String jdbc_driver = "oracle.jdbc.driver.OracleDriver";
String jdbc_url = "jdbc:oracle:thin:@localhost:1521/orcl.oracle.com";
try{
// JDBC 드라이버 로드
Class.forName(jdbc_driver);
// 데이터베이스 연결정보를 이용해 Connection 인스턴스 확보
conn = DriverManager.getConnection(jdbc_url,"SCOTT","tiger");
String sql = "insert into menux values(menux_s.nextval,?,?)";
pstmt = conn.prepareStatement(sql);
pstmt.setString(1,request.getParameter("mname"));
pstmt.setInt(2,Integer.parseInt(request.getParameter("price")));
rc = pstmt.executeUpdate();
}
catch(Exception e) {
System.out.println(e);
}
if(rc==0){
%>
<script>
alert('Insert error');
</script>
<%
}
%>
<script>
document.location = 'menuInsert.jsp';
//history.back();
</script>
