<%@ page contentType = "text/html; charset=utf-8" %>
<%@ page import = "java.sql.*" %>
<%
String name = request.getParameter("name");
String age = request.getParameter("age");
String gender = request.getParameter("gender");
Connection conn = null;
PreparedStatement pstmt = null;
String db = "jdbc:mysql://localhost:3306/example";
String user = "user";
String password = "1234";
try
{
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection(db, user, password); // user랑 password를 안쓰다니!
pstmt = conn.prepareStatement("INSERT INTO example1(name, age, gender)"
+ " VALUES(?, ?, ?)");
pstmt.setString(1, name);
pstmt.setString(2, age);
pstmt.setString(3, gender);
pstmt.executeUpdate(); // executeQuery가 아니었어 하하
} catch(SQLException ex) {
ex.printStackTrace();
} finally {
if(pstmt != null) { pstmt.close(); }
if(conn != null) { conn.close(); }
}
%>
<html>
<head>
<script type="text/javascript">
function checkForm()
{
var form = document.form;
if(form.name.value == '')
{
alert("이름을 쓰세요.");
form.name.focus();
return false;
}
if(form.age.value == '')
{
alert("나이를 쓰세요.");
form.age.focus();
return false;
}
if(form.gender[0].checked == false
&& form.gender[1].checked == false)
{
alert("성별을 선택하세요.");
return false;
}
return true;
}
</script>
</head>
<body>
<form name="form" method="post" action="list.jsp" onsubmit="return checkForm()">
이름: <input type="text" name="name"><br/>
나이: <input type="text" name="age"><br/>
성별: <input type="radio" name="gender" value="male">남성
<input type="radio" name="gender" value="female">여성<br/>
<input type="submit" value="완료">
</form>
</body>
</html>
