阅读背景:

如何使用jsp页面和tomcat 8编译和运行java文件

来源:互联网 

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



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: