求各位大神解决页面传值问题java.lang.NumberFormatException: null

最新推荐文章于 2023-08-02 15:07:36 发布

rambo丿

最新推荐文章于 2023-08-02 15:07:36 发布

阅读量418

点赞数

文章标签： jsp

本文链接：https://blog.csdn.net/qq_44649093/article/details/90761980

版权

这里写自定义目录标题

这是第一个jsp
<%@ page language=“java” contentType=“text/html; charset=UTF-8”
pageEncoding=“UTF-8”%>
<%@page import=“java.sql.*” %>

<table border="4"cellpadding="10">
<thead> 学生通讯录  </thead>
<tr>

姓名工作单位职位通讯地址邮编 QQ号微信号电子邮箱手机单位电话家庭电话其他信息操作

try {
	//加载mysql的jdbc驱动
	Class.forName("com.mysql.cj.jdbc.Driver");
	//获取连接
	Connection conn =DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql?serverTimezone=UTC", "root", "xushiyu??123");
	//用连接创造statement语句
	Statement st= conn.createStatement();
	//用statement执行查询sql
	ResultSet rs= st.executeQuery("select* from book3");
	//遍历结果集resultset		
	while(rs.next()){
		out.println("<tr><td>"+rs.getString("name")+"</td><td>"+rs.getString("unit")+"</td><td>"+rs.getString("position")
				+"</td><td>"+rs.getString("address")+"</td><td>"+rs.getString("zipcode")+"</td><td>"+rs.getInt("qqnumber")
				+"</td><td>"+rs.getString("weixin")+"</td><td>"+rs.getString("email")+"</td><td>"+rs.getString("phone")
				+"</td><td>"+rs.getString("cpphone")+"</td><td>"+rs.getString("homephone")+"</td><td>"+rs.getString("information")+"</td><td><a href='update.jsp?id="+ rs.getString("id") +"'>修改</a></tr>");
}
	rs.close();
	conn.close();

}

catch(ClassNotFoundException e){
	out.println("<div style='color:red;'>jdbc驱动找不到</div>");
	e.printStackTrace();

}
catch(SQLException e2){
e2.printStackTrace();
}

这是第二个jsp
<%@ page language=“java” contentType=“text/html; charset=UTF-8”
pageEncoding=“UTF-8”%>
<%@page import=“java.sql.*” %>

更新个人信息放回上一页：

姓名

<td><input type="text" name="name"placeholder="输入姓名"></td>
</tr>

工作单位职位通讯地址邮编 QQ号微信号电子邮箱手机单位电话家庭电话其他信息

</form>

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

try{

	

 
	//加载mysql的jdbc驱动
	Class.forName("com.mysql.jdbc.Driver");
	//获取连接
	Connection conn =DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql?serverTimezone=UTC&characterEncoding=UTF-8", "root", "xushiyu??123");
	//用连接创造statement语句		
	Statement st= conn.createStatement();		
	//用statement执行查询sql·
	String sql="select * from book3 where id ="+id;
	ResultSet rs= st.executeQuery(sql);
			rs.close();
			
	String  name=request.getParameter("name");		
	String  unit=request.getParameter("unit");
	String  position=request.getParameter("position");
	String  address=request.getParameter("address");
	String  zipcode=request.getParameter("zipcode");
	String qqnumber =request.getParameter("qqnumber");
	String  weixin=request.getParameter("weixin");
	String  email=request.getParameter("email");
	String  phone=request.getParameter("phone");
	String  cpphone=request.getParameter("cpphone");
	String  homephone=request.getParameter("homephone");
	String  information=request.getParameter("information");

	
	if(name !=null&& name.trim()!=""){
		String sql2="update book3 set  name  = ' "+  name  + " '  ,unit= '" + unit + "',position='" + position + "',address='" + address + "',zipcode='" + zipcode + "',qqnumber='" + qqnumber + "',weixin='" + weixin + "',email='" + email + "',phone='" + phone + "',cpphone='" + name + "',homephone='" + homephone + "',information='" + information + "'  ";
		st.execute(sql2);
	
	}
	st.close();
	conn.close(); 
	response.sendRedirect("book2.jsp");

}
catch(ClassNotFoundException e){
out.println("<div style='color:red;'>jdbc驱动找不到</div>");
e.printStackTrace();
}
catch(SQLException e2){
e2.printStackTrace();
}

他总是报错那个id是空的。求各位大神，那个应该怎么改？