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
47
48
49
50
51
52
<%@ 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" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<%
UUID bookToModify = UUID.fromString(request.getParameter("book"));
Class.forName("org.postgresql.Driver");
String url = "jdbc:postgresql://localhost/Aebi1?port=5432&user=postgres&password=123456";
Connection c = DriverManager.getConnection(url);
PreparedStatement pst= c.prepareStatement("SELECT id, title, year FROM books WHERE id = ?");
pst.setObject(1, bookToModify);
String currentID = "";
String currentTitle = "";
int currentYear = 0;
ResultSet result = pst.executeQuery();
if (result.next()) {
currentID = result.getString(1);
currentTitle = result.getString(2);
currentYear = result.getInt(3);
}
%>
<p>Buch ändern:</p>
<form action="update.jsp" method="get">
<input type="hidden" name= "id" value="<%=currentID %>"> <!-- hidden/unsichtbar, weil so können wir ein Buch ändern -->
<p>Titel:<input type="text" name="title" value="<%=currentTitle%>"></p>
<p>Jahr:<input type="text" name="jahr" value="<%=currentYear%>"></p>
<br/>
<div><input type="submit" value="Speichern"></div>
</form>
</body>
</html>