Skip to content
Snippets Groups Projects
modify.jsp 1.45 KiB
Newer Older
<%@ 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>