一直報編碼轉化錯誤，新手搞不懂，望大神幫忙
1.jsp
<%@ page language="java" import="java.util.*" contentType="text/html; charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<head>
<title>用戶資訊</title>
</head>
<% request.setCharacterEncoding("gbk");
response.setCharacterEncoding("gbk");
//String userid = request.getParameter("userid");
String userid =new String(request.getParameter("userid").getBytes("ISO8859_1"),"UTF-8");
System.out.print(userid);
Connection conn = null;
Statement stat = null;
ResultSet rs = null;
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/zhbit";
String user = "root";
String password = "ax191823503";
conn = DriverManager.getConnection(url,user,password);
stat = conn.createStatement();
rs = stat.executeQuery("select * from user where userid='" + userid + "'");
%>
<br>
<h2>用戶資訊</h2><hr>
<br>
<h3>要修改的用戶資訊如下</h3>
<table width="450" border="100" cellSpacing=1 style="font-size:15pt;border:dashed 1pt">
<tr>
<td>用戶id</td>
<td>名稱</td>
<td>密碼</td>
</tr>
<%
while(rs.next())
{
out.print("<tr>");
out.print("<td>" + rs.getString("userid") + "</td>");
out.print("<td>" + rs.getString("name") + "</td>");
out.print("<td>" + rs.getString("password") + "</td>");
out.print("</tr>");
%>
</table>
<br>
<h3>將用戶資訊更改為：</h3>
<form action="2.jsp" method="post" onSubmit="return validate()">
<h4> 用戶id：<input type="text" name="userid" value="https://bbs.csdn.net/topics/<%=rs.getString("userid") %>" title="用戶名不能改變" readonly="readonly"></input><br></h4>
<h4> 名稱：<input type="text" name="name" title="密碼不能為空" onClick="return checkName(name)"></input><br></h4>
<h4> 密碼：<input type="text" name="password" title="年齡不能為空"></input><br></h4>
<input type="submit" value="https://bbs.csdn.net/topics/修改"/>
</form>
<br>
<h3><a href=https://bbs.csdn.net/topics/addStuInfo.jsp>回傳添加資訊頁面
<h3><a href=https://bbs.csdn.net/topics/showInfo.jsp>回傳資訊查詢頁面
<%
}
%>
<%
if(rs != null)
{
rs.close();
rs = null;
}
if(stat != null)
{
stat.close();
stat = null;
}
if(conn != null)
{
conn.close();
conn = null;
}
%>
</body>
</html>
2.jsp
<%@ page language="java" import="java.util.*" contentType="text/html; charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html> <head>
<title>修改頁面</title>
</head>
<% request.setCharacterEncoding("gbk");
response.setCharacterEncoding("gbk");
String userid1 = request.getParameter("userid");
String name1 = request.getParameter("name");
String password1 = request.getParameter("password");
Connection conn = null;
Statement stat = null;
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/zhbit";
String user = "root";
String password = "ax191823503";
conn = DriverManager.getConnection(url,user,password);
stat = conn.createStatement();
stat.execute("update user set userid='" + userid1 + "',name='" + name1 + "',password='" + password1 + "' where userid='" + userid1 + "'");
ResultSet rs = stat.executeQuery("select * from user where userid='" + userid1+"'");
%>
<br>
<h3>修改成功！</h3>
<br>
<h3>修改后的資訊為：</h3>
<hr>
<br>
<br>
<table width="450" border="100" cellSpacing=1 style="font-size:15pt;border:dashed 1pt">
<tr>
<td>用戶id</td>
<td>用戶名稱</td>
<td>密碼</td>
</tr>
<%
while(rs.next())
{
out.print("<tr>");
out.print("<td>" + rs.getString("userid") + "</td>");
out.print("<td>" + rs.getString("name") + "</td>");
out.print("<td>" + rs.getString("password") + "</td>");
out.print("</tr>");
}
%>
</table>
<br>
<br>
<h3><a href=https://bbs.csdn.net/topics/usermanage.jsp>回傳添加資訊頁面
<%
if(rs != null)
{
rs.close();
rs = null;
}
if(stat != null)
{
stat.close();
stat = null;
}
if(conn != null)
{
conn.close();
conn = null;
}
%>
</body>
</html>
uj5u.com熱心網友回復：
request.getParameter("userId") 是null ，寫個三元吧uj5u.com熱心網友回復：
額？咋寫 新手不太懂
uj5u.com熱心網友回復：
給userid賦值，或者加個判斷/校驗uj5u.com熱心網友回復：
A:B?C 三元A可以是變數也可以是運算式
B、C是結果
https://blog.csdn.net/weixin_42193830/article/details/88747991
uj5u.com熱心網友回復：
試試把
String userid =new String(request.getParameter("userid").getBytes("ISO8859_1"),"UTF-8");
換成
String userid =new String(request.getParameter("userid").getBytes("ISO-8859-1"),"UTF-8")
uj5u.com熱心網友回復：
給userid賦值，或者加個判斷/校驗轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/61701.html
標籤：Web 開發