Untitled

<%@ page import="java.sql.ResultSet" %>
<%@ page import="java.sql.SQLException" %>
<%@ page import="java.sql.Statement" %>
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.DriverManager" %>

<html>
<head>
    <title>Søke etter personer i faget</title>
</head>
<body>
<%
    String keyword = "";
    if(request.getParameter("txtKeyword") != null) {
        keyword = request.getParameter("txtKeyword");
    }
%>

    <form name="frmSearch" method="get" action="index.jsp">
      <table width="599" border="1">
        <tr>
          <th>Søk
          <input name="txtKeyword" type="text" id="txtKeyword" value="<%=keyword%>" placeholder="Søk etter navn">
          <input type="submit" value="Search"></th>
        </tr>
      </table>
    </form>

    <%
    Connection connect = null;
    Statement s = null;

    try {
        Class.forName("com.mysql.jdbc.Driver");

        connect =  DriverManager.getConnection("jdbc:mysql://localhost/Slit" + "?user=root&password=root");

        s = connect.createStatement();

        String sql = "SELECT *  FROM  student WHERE Student_Name like '%" +  keyword + "%' " +
        " ORDER BY Student_Name ASC";

        System.out.println(sql);

        ResultSet rec = s.executeQuery(sql);
        %>
        <table width="600" border="2">
          <tr>
            <th width="91"> <div align="center">Bruker ID </div></th>
            <th width="98"> <div align="center">Name </div></th>
            <th width="198"> <div align="center">Email </div></th>

          </tr>
            <%while((rec!=null) && (rec.next())) { %>
                  <tr>
                    <td><div align="center"><%=rec.getString("Student_ID")%></div></td>
                    <td><%=rec.getString("Student_name")%></td>
                    <td><%=rec.getString("Email")%></td>

            <%}%>
        </table>
        <%
        } catch (Exception e) {
            // TODO Auto-generated catch block
            out.println(e.getMessage());
            e.printStackTrace();
        }

        try {
            if(s!=null){
                s.close();
                connect.close();
            }
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            out.println(e.getMessage());
            e.printStackTrace();
        }

    %>
</body>
</html>