<!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>
Jsp mysql 乱码问题
最新推荐文章于 2021-02-26 07:40:00 发布