2016. 9. 7. 17:45ㆍ프로그래밍/jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
<link rel="stylesheet" href="comm.css" type="text/css">
</head><body><form action="MyDivisionInsert.jsp"><table>
<caption>부서정보 입력</caption>
<tr><th>부서코드</th><td><input type="number" name="dno"
required="required"></td></tr>
<tr><th>부서명</th><td><input type="text" name="dname"
required="required"></td></tr>
<tr><th>전화번호</th><td><input type="tel" name="phone"
required="required" placeholder="xxx-xxxx-xxxx"></td></tr>
<tr><th>근무지</th><td><input type="text" name="position"
required="required"></td></tr>
<tr><th colspan="2"><input type="submit" value="확인">
</th></tr></table></form>
</body>
</html>
html로 입력받을 정보 기입
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8" import="java.sql.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<% String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://127.0.0.1:3306/test?useSSL=false";
String dno = request.getParameter("dno");
String dname = request.getParameter("dname");
String phone = request.getParameter("phone");
String position = request.getParameter("position");
String sql = String.format(
"insert into division values (%s,'%s','%s','%s')",
dno, dname, phone, position);
Connection conn = null; Statement stmt = null;
try {
Class.forName(driver);
conn = DriverManager.getConnection(url,"root","mysql");
stmt = conn.createStatement();
int result = stmt.executeUpdate(sql);
if (result > 0) response.sendRedirect("MyUpdateSelect.jsp");
else out.println("으이그 또 실패야~ 다시 한번 해봐!");
}catch(Exception e) {
System.out.println(e.getMessage());
out.println("입력 실패야~ 다시 한번 힘을 내!");
}finally {
if (stmt != null) stmt.close();
if (conn != null) conn.close();
}
%>
</body>
</html>
'프로그래밍 > jsp' 카테고리의 다른 글
| 게시판 답글 관련... 작성중 (0) | 2016.09.20 |
|---|---|
| 작성중인 문서입니다! (0) | 2016.09.07 |
| html에서 부서코드를 입력받아 Mysql 실행 (0) | 2016.09.06 |
| mysql 연동하기 (0) | 2016.09.06 |
| 피보나치 수열 합산! (0) | 2016.09.01 |