xampp mysql 内存溢出_java - java.lang.NumberFormatException：null java.lang.Integer.parseInt（未知来源） - 堆栈内存...

我试图从jsp页面获取值，并希望使用java将这些值存储在mysql(xampp)数据库中。 建立连接并成功登录，但是当我尝试获取值时，发生空指针异常

MainController.java是

package classes;

import java.io.IOException;

import java.sql.Connection;

import java.sql.Date;

import java.sql.DriverManager;

//import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.sql.Time;

import javax.servlet.RequestDispatcher;

import javax.servlet.ServletContext;

import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import javax.servlet.http.HttpSession;

/**

* Servlet implementation class MainController

*/

@WebServlet("/MainController")

public class MainController extends HttpServlet {

private static final long serialVersionUID = 1L;

/**

* @see HttpServlet#HttpServlet()

*/

public MainController() {

super();

// TODO Auto-generated constructor stub

}

/**

* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse

* response)

*/

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

/**

* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse

* response)

*/

}

//@SuppressWarnings("null")

protected void doPost(HttpServletRequest request,

HttpServletResponse response) throws ServletException, IOException {

String url= "jdbc:mysql://localhost/meeting_planner";

System.out.println("start");

// boolean stfound = false;

try {

System.out.println("reached controller");

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

Connection con = DriverManager.getConnection(url, "admin", "admin");

Statement stmt = con.createStatement();

//System.out.println("connection");

String button=request.getParameter("button");

System.out.println(button + request.getParameter("AId"));

if(button.equals("login"))

{

System.out.println("inside if");

String AdminId= request.getParameter("AId");

String password= request.getParameter("Password");

System.out.println(AdminId+" sadia "+password);

if(!(AdminId=="" || password==""))

{

boolean stfound = false;

System.out.println(AdminId+" sadia "+password);

String query = "SELECT AId,Password FROM administrator";

ResultSet rs = stmt.executeQuery(query);

System.out.println(query);

while(rs.next())

{

String dbadminid = rs.getString(1);

String dbadminpwd = rs.getString(2);

if(AdminId.equals(dbadminid) && password.equals(dbadminpwd))

{

HttpSession session = request.getSession(true);

session.setAttribute("userid",dbadminid);

stfound = true;

break;

}

}

if(stfound){

RequestDispatcher dispatcher = getServletContext().getRequestDispatcher ( "/meeting_Id.jsp" ) ;

dispatcher.forward ( request, response ) ;

}

}

else{

RequestDispatcher dispatcher = getServletContext().getRequestDispatcher ( "/index.jsp" ) ;

dispatcher.forward ( request, response ) ;

}

}

if(button.equals("Next"))

{

HttpSession session = request.getSession(true);

String AID =(String) session.getAttribute("aid");

int meetingid = Integer.parseInt(request.getParameter("meeting_id"));

/*String CNM= request.getParameter("CNM");

int CCD = Integer.parseInt(request.getParameter("CCD"));

int CCDD= Integer.parseInt(request.getParameter("CCDD"));

int PID= Integer.parseInt(request.getParameter("PID"));

int STFID=Integer.parseInt(AID);*/

meeting obj=new meeting();

obj.addmeeting(meetingid);

System.out.print("Sadia");

RequestDispatcher dispatcher = getServletContext().getRequestDispatcher ( "/creat_date.jsp" ) ;

dispatcher.forward ( request, response ) ;

}

}catch (ClassNotFoundException e1) {

// TODO Auto-generated catch block

e1.printStackTrace();

} catch (SQLException e1) {

// TODO Auto-generated catch block

e1.printStackTrace();

}

}

}

和Meeting.java是

package classes;

import java.sql.Connection;

import java.sql.Date;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Time;

import java.sql.Statement;

public class meeting {

private int meeting_id;

Connection con=null;

Statement smt = null;

public static void main(String[] args) {

// TODO Auto-generated method stub

}

public meeting()throws ClassNotFoundException//construtor

, SQLException{

// try{

String url = "jdbc:mysql://localhost/meeting_planner";

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

con = DriverManager.getConnection(url, "admin", "admin");

smt = con.createStatement();

//}catch(ClassNotFoundException e1){

//e1.printStackTrace();

}

public void addmeeting(int meeting_id1)throws ClassNotFoundException // from attribute web.xml

, SQLException{

System.out.println("------TRY INSERTION------");

String query = "SELECT meeting_Id FROM meeting";

ResultSet rs = smt.executeQuery(query);

int numCols = rs.getMetaData().getColumnCount()+1;

// STAFF_ID=numCols+1;

String query1 = "INSERT INTO Meeting VALUE ( "+meeting_id+")";

System.out.println(query1);

smt.executeUpdate(query1);

}

}

当我在此行中打印next的值时，Next按钮的名称为“ next”； System.out.println("next"+next); 它为下一个参数输出null

**编辑：NullPointerException的问题已解决，但现在引发了NumberFormatException **

控制台是这样的

start

reached controller

inside if

111 sadia sadia

111 sadia sadia

SELECT AId,Password FROM administrator

start

reached controller

Oct 29, 2014 6:44:57 PM org.apache.catalina.core.StandardWrapperValve invoke

SEVERE: Servlet.service() for servlet [classes.MainController] in context with path [/Meeting1] threw

exception

java.lang.NumberFormatException: null

at java.lang.Integer.parseInt(Unknown Source)

at java.lang.Integer.parseInt(Unknown Source)

at classes.MainController.doPost(MainController.java:141)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)

at

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)

at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)

at

org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)

at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

index.jsp是

Enter id:

id="AId" name="AId" required="required" />

Enter_password:

type="password" name="Password" required="required" />

name="button" " value="login"

style="height: 30px; width: 70px">

meeting_Id.jsp是

Enter Meeting Id: