Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.io.IOException;
- import java.io.PrintWriter;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.sql.Statement;
- import javax.servlet.ServletException;
- import javax.servlet.annotation.WebServlet;
- import javax.servlet.http.HttpServlet;
- import javax.servlet.http.HttpServletRequest;
- import javax.servlet.http.HttpServletResponse;
- @WebServlet("/Servlet")
- public class Servlet extends HttpServlet {
- private static final long serialVersionUID = 1L;
- public Servlet() {
- super();
- }
- PrintWriter out;
- Connection con;
- ResultSet rs;
- Statement stat;
- private String prolog = "<html><title>Baza ksiazek</title>";
- private String epilog = "</body></html>";
- protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
- response.setContentType("text/html; charset=ISO-8859-2");
- try {
- Class.forName("oracle.jdbc.driver.OracleDriver");
- out = response.getWriter();
- con = DriverManager.getConnection("jdbc:oracle:thin:@db-oracle:1521:baza","s15224","oracle12");
- stat = con.createStatement();
- rs = stat.executeQuery("SELECT * FROM KSIAZKA");
- toPage();
- if(request.getParameter("ident")!=null){
- String s = request.getParameter("ident");
- rs = stat.executeQuery("SELECT * FROM KSIAZKA WHERE AUTOR='"+s+"'");
- response.reset();
- toPage();
- }
- } catch (SQLException e) {
- System.out.println("SQL exception: "+e.toString());
- } catch (ClassNotFoundException e) {
- System.out.println("class exception: "+e.toString());
- }
- }
- private void toPage() {
- StringBuilder buf = new StringBuilder();
- buf.append(prolog+"<body>");
- buf.append("<form method=\"get\" action=\"http://localhost:8080/TPO4_PJ_S152241/Servlet\">"
- + "<input type=\"text\" size=\"50\" name=\"ident\"><input type=\"submit\" value=\"search\"></form>");
- buf.append("<table>" +
- "<tr>" +
- "<th>Tytul</th>" +
- "<th>Autor</th>" +
- "<th>Wydawnictwo</th>" +
- "<th>Rok wydania</th>"+
- "</tr>");
- try {
- while (rs.next()) {
- buf.append("<tr><td>"+rs.getString("TYTUL") + "</td><td>"+ rs.getString("AUTOR") + "</td><td>" + rs.getString("WYDAWNICTWO")+"</td><td>" + rs.getString("ROK")+"</td></tr>");
- }
- } catch (SQLException e) {
- e.printStackTrace();
- }
- buf.append("</table>"+epilog);
- out.println(buf);
- }
- protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
- doGet(request, response);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement