html에서 부서코드를 입력받아 Mysql 실행

프로그래밍/jsp

오코딩 2016. 9. 6. 17:47

<!DOCTYPE html>

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">

<title>Insert title here</title>

</head>

<body>

<h2> 부서코드 입력</h2>

<form action="MyDivisionSelectDept.jsp">

부서코드 : <input type="number" name="dno" required="required"><p>

<input type="submit" value="확인">

</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 dno = request.getParameter("dno");

String driver = "com.mysql.jdbc.Driver";

String url = "jdbc:mysql://127.0.0.1:3306/test?useSSL=false";

String sql = "select * from division where dno="+dno;

Connection conn=null; Statement stmt=null; ResultSet rs=null;

try { Class.forName(driver);

conn=DriverManager.getConnection(url,"root","mysql");

stmt = conn.createStatement();

rs = stmt.executeQuery(sql);

if (rs.next()) {

out.println("부서코드 : "+dno+"<p>");

out.println("부서명 : "+rs.getString(2)+"<p>");

out.println("전화번호 : "+rs.getString(3)+"<p>");

out.println("근무지 : "+rs.getString(4));

} else out.println("없는 부선데");

}catch(Exception e) { System.out.println(e.getMessage());

}finally {

if (rs != null) rs.close();

if (stmt != null) stmt.close();

if (conn != null) conn.close();

}

</body>

</html>