<title>Insert title here</title>
<script src="http://code.jquery.com/jquery-latest.js"></script>
<script type="text/javascript">
function checktest(){
document.abc.submit();
}
</script>
<style>
tr, td{
text-align:left;
}
.header{
text-align:center;
}
.footer{
border-top:1px solid gray
}
div{
margin:5px;
}
table{
width:450px;
margin:auto;
}
</style>
</head>
<body>
<div style="width:500px">
<div class="header">
<p>제조사명 조회</p>
</div>
<div>
<table border="2" summary="???">
<thead>
<tr>
<td colspan="2" style="text-align:center">제품코드(4) 입력</td>
</tr>
</thead>
<form name="abc" method="post" action="testview.jsp">
<tbody>
<tr>
<td>제품코드</td>
<td><input type="text" name="code"></td>
</tr>
</tbody>
<tfoot>
<tr>
<td colspan="2" style="text-align:center"><button onclick="checktest()">확인</button></td>
</tr>
</tfoot>
</form>
</table>
</div>
<div>
</div>
</div>
</body>
제품코드를 입력해서 textview.jsp로 던저준다.
<%@ page language="java" import="java.sql.*" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%
Class.forName("oracle.jdbc.driver.OracleDriver");
String url= "jdbc:oracle:thin:@localhost:1521:xe";
Connection dbconn=DriverManager.getConnection(url,"edujh","1234");
Statement stmt=dbconn.createStatement();
String code=request.getParameter("code");
ResultSet rs=stmt.executeQuery("SELECT * FROM PRODUCTINFO WHERE PROCODE='"+code+"'");
String result_procompa="등록되지 않은 제품입니다!";
if(rs.next()){
result_procompa=rs.getString("PROCOMPA");
}
%>
<!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>jsp로 출력!</title>
<style>
tr, td{
text-align:left;
}
.header{
border-bottom:1px solid gray;
}
.footer{
border-top:1px solid gray
}
div{
margin:5px;
}
table{
width:450px;
margin:auto;
border-collapse:collapse;
}
</style>
</head>
<body onload="clock()">
<div style="width:500px">
<div class="header">
<p style="text-align:center">제품코드 조회 결과</p>
</div>
<div>
<table border="1">
<tr>
<td style="text-align:center" colspan="2">제조사 조회 결과</td>
</tr>
<tr>
<td style="width:30%">제품코드</td>
<td style="width:70%"><%=code%></td>
</tr>
<tr>
<td style="width:30%">제조사명</td>
<td style="width:70%"><%=result_procompa%></td>
</tr>
<tr >
<td style="width:30%">조회일시</td>
<td style="width:70%" ><span id="demo"></span></td>
</tr>
</table>
</div>
<div class="footer">
<p style="text-align:center">작성자 이정혁 비번:1234 작성일: 2017-12-14</p>
</div>
</div>
<%
stmt.close();
dbconn.close();
%>
<script type="text/javascript">
function clock(){
//document.getElementById("demo").innerHTML = Date();
var onclock=document.getElementById("demo");
var nowclock=new Date();
var days=["Sun","Mon","Tue","Wed","Thu","Fri","Sat"];
var month=["Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"];
var date=days[nowclock.getDay()]+" "+month[nowclock.getMonth()]+" "+nowclock.getDate()+" "+nowclock.getHours()+":"+nowclock.getMinutes()+":"+nowclock.getSeconds()+" LJH "+nowclock.getFullYear();
onclock.innerHTML=date;
}
</script>
</body>
받은값을 이용하여 select문을 수행하고 값이 존재하면 출력한다
받은 값이 없거나 DB에 없으면 이와 같은 무구를 뜨게 한다.
'공부!' 카테고리의 다른 글
| JSP 기초 (0) | 2017.12.21 |
|---|---|
| JSP alert 함수, confirm 함수, prompt 함수 (0) | 2017.12.20 |
| 자바스크립트 시간/날짜 표시하기! (0) | 2017.12.14 |
| html 테이블 만들기2 (0) | 2017.12.11 |
| html 테이블 만들기 (0) | 2017.12.11 |
