버튼이 클릭된 시간을 DB에 저장하려고 하는데 페이지를 새로고침해도 저장이되고 한번에 테이블 2개에 모두 저장이 되네요..
파일은 jsp파일 입니다. 함수를 밖으로 빼서 불러와야 할까요?;;
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<%@page import="java.util.Calendar" %>
<%@ page import="java.sql.*" %>
<%@ page import="javax.sql.*" %>
<%@ page import="javax.naming.*" %>
<!DOCTYPE html >
<%
Calendar c = Calendar.getInstance();
int year = c.get(Calendar.YEAR);
int month = c.get(Calendar.MONTH);
int day = c.get(Calendar.DATE);
int hour = c.get(Calendar.HOUR_OF_DAY);
int minute = c.get(Calendar.MINUTE);
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Insert title here</title>
<script type="text/javascript">
function t(){
alert( <h1><%=hour %>시<%=minute %>분 확인
좋은하루되세요</h1>);
<%
Connection conn = null;
PreparedStatement pstmt=null;
try {
Context init = new InitialContext();
DataSource ds = (DataSource) init.lookup("java:comp/env/jdbc/OracleDB");
conn = ds.getConnection();
Statement stmt = conn.createStatement();
pstmt=conn.prepareStatement("INSERT INTO timecheck VALUES (?,?,?,?,?)");
pstmt.setInt(1,year);
pstmt.setInt(2,month);
pstmt.setInt(3,day);
pstmt.setInt(4,hour);
pstmt.setInt(5,minute);
int result = pstmt.executeUpdate();
}catch(Exception e){
e.printStackTrace();
}
%>
}
function c(){
alert( <h1><%=hour %>시<%=minute %>분 확인
수고하셨습니다</h1>);
<%
try {
Context init = new InitialContext();
DataSource ds = (DataSource) init.lookup("java:comp/env/jdbc/OracleDB");
conn = ds.getConnection();
Statement stmt = conn.createStatement();
pstmt=conn.prepareStatement("INSERT INTO outtime VALUES (?,?,?,?,?)");
pstmt.setInt(1,year);
pstmt.setInt(2,month);
pstmt.setInt(3,day);
pstmt.setInt(4,hour);
pstmt.setInt(5,minute);
int result = pstmt.executeUpdate();
}catch(Exception e){
e.printStackTrace();
}
%>
}
</script>
</head>
<body>
<input type="button" onclick="t();" value="출 근">
<input type="button" onclick="c();" value="퇴 근">
</body>
</html>