Untitled

------------index-----------------------


<html>
    <head>
        <title>TODO supply a title</title>
        <meta charset="UTF-8">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
    </head>
    <body>
      <form name="firstform" method="post" action="test.jsp">
        ID: <input type="text" name="id"> <br>
        Name: <input type="text" name="name"> <br>
        <input type="submit" value="Submit"> <br>
      </form>
    </body>
</html>


------------------------------jsp---------------------------


<%--
    Document   : test
    Created on : 8 Απρ 2016, 2:52:04 μμ
    Author     : user
--%>

      <%@page import="java.sql.*" %>
      <%@page contentType="text/html" pageEncoding="UTF-8"%>
      <%
          int j=0;
// Define parameters for retrieving database results
int m[] = new int[5000];

String id=request.getParameter("ID");
String name=request.getParameter("Name");


// Load the driver
Class.forName("com.mysql.jdbc.Driver");
// Define the connection parameters
String myDatabase = "jdbc:mysql://localhost:3306/mydb1?user=root&password=rootP";
// Connect to the database
Connection myConnection = DriverManager.getConnection(myDatabase);

// Create object to execute statements
Statement myStatement = myConnection.createStatement();
String sqlString = "Insert into myTable values(" +id+",'"+name+"')";

myStatement.executeUpdate(sqlString);

// Close the connection to the database
myStatement.close();
myConnection.close();

// Print
//out.println("j="+j+"<br>");
//for(int i=0; i<j; i++) {
//    out.println(m[i]+"");
//    out.println(s[i]+"<br>");
//}
      %>