Jsp mysql 乱码问题

最新推荐文章于 2021-02-26 07:40:00 发布

chengest

最新推荐文章于 2021-02-26 07:40:00 发布

阅读量76

点赞数

分类专栏： JAVA 文章标签： MySQL JSP SQL Java JDBC

JAVA 专栏收录该内容

18 篇文章 0 订阅

订阅专栏


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<%@ page contentType="text/html; charset=GBK" language="java" import="java.sql.*" errorPage="" %>
<meta http-equiv="Content-Type" content="text/html; charset=GBK" />
<title>test of mysql</title>
<link href="style.css" type="text/css" rel="stylesheet">
</head>

<body>
<div id="wrapper">
<%@ include file="include/header.jsp"%>
<table width="800" border="2"align="center" cellspacing="20"cellpadding="20"><tr><td>

<table width="300" border="1">
<tr>
<td>序号</td>
<td>姓名</td>
</tr>
<%
String driverName="org.gjt.mm.mysql.Driver";
String dbName="test";
String tableName="people";
String url="jdbc:mysql://localhost:3306/"+dbName+"?user=root&password=lingting&useUnicode=true&characterEncoding=GBK";

Class.forName(driverName).newInstance();

Connection conn=DriverManager.getConnection(url);

Statement stmt = conn.createStatement();

String sql="SELECT * FROM "+tableName;

ResultSet rs = stmt.executeQuery(sql);

while(rs.next()) {
   String str_name=new String(rs.getString("name").getBytes("ISO-8859-1"),"GBK");
 %>
<tr>
<td><%= rs.getString("id") %></td>
<td><a href="view.jsp?id=<%= rs.getString("id") %>"><%= str_name %></a></td>
</tr>
<%}  
out.println("数据库操作成功，恭喜你");
rs.close();  
stmt.close();  
conn.close();  
%>
</table>

</td></tr></table>
</div>
<%@ include file="include/footer.jsp"%>
</body>
</html>