alumini.java:
import java.util.*;
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class alumini extends HttpServlet {
public void doGet(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException{
String aluno=req.getParameter("aluno");
String fname=req.getParameter("fname");
String mname=req.getParameter("mname");
String lname=req.getParameter("lname");
String passyr=req.getParameter("passyr");
String dept=req.getParameter("dept");
String enroll=req.getParameter("enroll");
String connectionURL="jdbc:mysql://localhost:3306/test"; //connection variable
Connection connection = null;
PreparedStatement st = null;
try {
Class.forName("com.mysql.jdbc.Driver");
connection = DriverManager.getConnection
(connectionURL, "root", "");
String sql = "insert into alumini (aluno,fname,mname,lname,passyr,dept,enroll) values (?, ?, ?, ?, ?, ?, ?)";
st = connection.prepareStatement(sql);
st.setString(1, aluno);
st.setString(2, fname);
st.setString(3, mname);
st.setString(4, lname);
st.setString(5, passyr);
st.setString(6, dept);
st.setString(7, enroll);
st.executeUpdate();
st.close();
connection.close();
}catch(Exception E){
System.out.println("The error is=="+E.getMessage());
}
}
}
import java.util.*;
import java