Newer
Older
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import ="java.sql.Connection" %>
<%@ page import ="java.sql.DriverManager" %>
<%@ page import ="java.sql.PreparedStatement" %>
<%@ page import ="java.sql.ResultSet" %>
<%@ page import ="java.util.UUID" %>
<%@ page import ="java.sql.Date" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<%
// Parameter lesen
UUID user = UUID.fromString(request.getParameter("user"));
UUID book = UUID.fromString(request.getParameter("book"));
String dateAsString = request.getParameter("datum");
java.util.Date date1 = new java.text.SimpleDateFormat("dd.MM.yyyy").parse(dateAsString);
Class.forName("org.postgresql.Driver");
String url = "jdbc:postgresql://localhost/Aebi1?port=5432&user=postgres&password=123456";
Connection c = DriverManager.getConnection(url);
UUID id = UUID.randomUUID();
PreparedStatement pst= c.prepareStatement("INSERT INTO books_users (id, \"user\", book, return_date) "+" VALUES (? ,?, ?, ?);");
pst.setObject(1, id);
pst.setObject(2, user);
pst.setObject(3, book);
java.sql.Date date2 = new java.sql.Date(date1.getTime());
pst.setDate(4, date2);
pst.execute();
response.sendRedirect("index.jsp");
%>
</body>
</html>