先来两个简单的页面
第一个是lmess.jsp 这个页面主要是给用户留言的 有文本域
----------------------------------------------------------------
<%@ page language="java" pageEncoding="gbk" contentType="text/html;charset=gbk"%>
<%@page import="DB.DBFile"%>
<%@ page import="java.sql.*" %><jsp:include page="head.jsp"/>
<div id="head5">
<div style="float:left; margin-left:5px; "><img src="img/jian.gif"></div>
<div style="margin-top:4px; "><font class="h5f"><b> 当前位置:</b><a href="index.jsp">
<font class="h5f">首页</font></a>→客户留言</font></div>
</div>
</div>
<div id="list">
<div id="r12zz">
<div id="r1211">
<div id="rl21a"><font color="#605955">客户留言</font></div>
<div style="float:right; margin-right:20px;margin-top:5px;"></div>
</div>
</div>
<div class="reg">
<div style=" text-align:left; background-color:#ECF5FB">
<table width="761" border="1" cellspacing="1" cellpadding="1"><tr></tr>
</table>
<table width="761" border="1" cellspacing="1" cellpadding="1">
<%
DBFile db = new DBFile();
Connection conn = db.getConnection();
String sql;
sql = "select * from _lmess order by id desc";
ResultSet rs =db.getStatement(conn).executeQuery(sql);
boolean flag = true;
while(rs.next()) { flag =false;
%>
<tr>
<%System.out.println(new String(rs.getString("content").getBytes("gb2312"),"gbk"));
System.out.println(rs.getString("content"));
System.out.println(new String(rs.getString("content").getBytes("iso8859-1"),"gbk"));
System.out.println(new String(rs.getString("content").getBytes("iso8859-1"),"gb2312"));
System.out.println(new String(rs.getString("content").getBytes("utf-8"),"gbk"));
%><td width="600" height="67"><font size=2><%=new String(rs.getString("content").getBytes("gb2312"),"gbk") %></font></td>
<td width="148">留言日期:<font color=red><%=rs.getString("riqi") %></font></td>
</tr>
<%} if(flag) {
%>
<tr>
<td align = center><font color=red>暂无留言~~~</font></td>
</tr>
<%} %>
</table>
<form action="crenew.jsp" method="post" name="reg">
<table width="300" border="1" cellpadding="1" cellspacing="1" bgcolor="#FFFFCC" ><tr><td width="123" class="STYLE3"><table width="300" border="1" cellpadding="1" cellspacing="1" bgcolor="#FFFFCC" >
<tr>
<td colspan="4" class="STYLE3">多多留言:(不超过100字)</td>
</tr>
<tr>
<td colspan="4"><textarea name="content" id="content" cols="45" rows="5"></textarea></td>
</tr>
<tr>
<td colspan="4"><div align="center">
<input type="submit" value="添加留言" />
|
<input type="reset" value="重置" />
</div></td>
</tr>
</table></td>
</tr>
</table>
</form>
<%
if(rs!=null) {
rs.close();
rs=null;}
db.closeAll();
%>
</div>
</div>
</div>
<jsp:include page="bottom.jsp"/> 这是crenew.jsp 主要是收集留言插入到数据库
-----------------------------------------------------------------------------------
<%@ page language="java" pageEncoding="gbk" contentType="text/html; charset=gbk"%>
<%@page import="DB.DBFile"%>
<%@ page import="java.sql.*" %>
<%//request.setCharacterEncoding("utf-8");
String content = new String(request.getParameter("content").getBytes("gbk"),"gb2312");
DBFile db = new DBFile();
Connection conn = db.getConnection();
String sql;
sql = "insert into _lmess (content ,riqi) values ('"+content+"',now())";
db.getStatement(conn).executeUpdate(sql);
db.closeAll();
%>
<script language = "javascript">
alert("留言成功!继续操作");
window.top.location.href="lmess.jsp";
</script>--------------------------------------------------------------------------
我的数据库字符集是gb2312
以前里面存的都是简体字
现在想存繁体字 主要是要显示出来不乱码就行啦
但是我试了再试 还是乱码
希望大侠们能帮我 正确显示简体和繁体
一旦有满意答案 就 结贴
第一个是lmess.jsp 这个页面主要是给用户留言的 有文本域
----------------------------------------------------------------
<%@ page language="java" pageEncoding="gbk" contentType="text/html;charset=gbk"%>
<%@page import="DB.DBFile"%>
<%@ page import="java.sql.*" %><jsp:include page="head.jsp"/>
<div id="head5">
<div style="float:left; margin-left:5px; "><img src="img/jian.gif"></div>
<div style="margin-top:4px; "><font class="h5f"><b> 当前位置:</b><a href="index.jsp">
<font class="h5f">首页</font></a>→客户留言</font></div>
</div>
</div>
<div id="list">
<div id="r12zz">
<div id="r1211">
<div id="rl21a"><font color="#605955">客户留言</font></div>
<div style="float:right; margin-right:20px;margin-top:5px;"></div>
</div>
</div>
<div class="reg">
<div style=" text-align:left; background-color:#ECF5FB">
<table width="761" border="1" cellspacing="1" cellpadding="1"><tr></tr>
</table>
<table width="761" border="1" cellspacing="1" cellpadding="1">
<%
DBFile db = new DBFile();
Connection conn = db.getConnection();
String sql;
sql = "select * from _lmess order by id desc";
ResultSet rs =db.getStatement(conn).executeQuery(sql);
boolean flag = true;
while(rs.next()) { flag =false;
%>
<tr>
<%System.out.println(new String(rs.getString("content").getBytes("gb2312"),"gbk"));
System.out.println(rs.getString("content"));
System.out.println(new String(rs.getString("content").getBytes("iso8859-1"),"gbk"));
System.out.println(new String(rs.getString("content").getBytes("iso8859-1"),"gb2312"));
System.out.println(new String(rs.getString("content").getBytes("utf-8"),"gbk"));
%><td width="600" height="67"><font size=2><%=new String(rs.getString("content").getBytes("gb2312"),"gbk") %></font></td>
<td width="148">留言日期:<font color=red><%=rs.getString("riqi") %></font></td>
</tr>
<%} if(flag) {
%>
<tr>
<td align = center><font color=red>暂无留言~~~</font></td>
</tr>
<%} %>
</table>
<form action="crenew.jsp" method="post" name="reg">
<table width="300" border="1" cellpadding="1" cellspacing="1" bgcolor="#FFFFCC" ><tr><td width="123" class="STYLE3"><table width="300" border="1" cellpadding="1" cellspacing="1" bgcolor="#FFFFCC" >
<tr>
<td colspan="4" class="STYLE3">多多留言:(不超过100字)</td>
</tr>
<tr>
<td colspan="4"><textarea name="content" id="content" cols="45" rows="5"></textarea></td>
</tr>
<tr>
<td colspan="4"><div align="center">
<input type="submit" value="添加留言" />
|
<input type="reset" value="重置" />
</div></td>
</tr>
</table></td>
</tr>
</table>
</form>
<%
if(rs!=null) {
rs.close();
rs=null;}
db.closeAll();
%>
</div>
</div>
</div>
<jsp:include page="bottom.jsp"/> 这是crenew.jsp 主要是收集留言插入到数据库
-----------------------------------------------------------------------------------
<%@ page language="java" pageEncoding="gbk" contentType="text/html; charset=gbk"%>
<%@page import="DB.DBFile"%>
<%@ page import="java.sql.*" %>
<%//request.setCharacterEncoding("utf-8");
String content = new String(request.getParameter("content").getBytes("gbk"),"gb2312");
DBFile db = new DBFile();
Connection conn = db.getConnection();
String sql;
sql = "insert into _lmess (content ,riqi) values ('"+content+"',now())";
db.getStatement(conn).executeUpdate(sql);
db.closeAll();
%>
<script language = "javascript">
alert("留言成功!继续操作");
window.top.location.href="lmess.jsp";
</script>--------------------------------------------------------------------------
我的数据库字符集是gb2312
以前里面存的都是简体字
现在想存繁体字 主要是要显示出来不乱码就行啦
但是我试了再试 还是乱码
希望大侠们能帮我 正确显示简体和繁体
一旦有满意答案 就 结贴
解决方案 »
- bean实例化失败
- tomcat无法启动,log提示没有tomcat-juli.jar,但实际有且路径已经配置
- hibernate组件映射是否可以提高性能?
- 很奇怪问题 有关request.getParameter
- 有关dwr传list 和 联动的问题
- hibernate的一个错误,谢谢
- 请教Hibernate问题
- 为什么用那个weblogic提供的软件update license时提示bea.*.*什么的包找不到?
- 关于struts的问题!(up者有分!)
- Spring boot maven plugin总是下载失败
- 新人,用java连接sql server2000出问题,是用jdbc,帮忙看下
- struts2 URL中文参数
String content = new String(request.getParameter("content").getBytes("gbk"),"gb2312"); 改成 request.setCharacterEncoding("GBK"); // 这里当然是GBK啊,怎么是UTF-8?
String content = request.getParameter("content"); // 这样就行了
String content = request.getParameter("content").getBytes("iso-8859-1"),"gb2312"); //这样试试一般都使用charset=gb2312
有时可能因为开发环境的不同或异常和导致
http://family168.com/tutorial/jsp/html/jsp-ch-02.html#jsp-ch-02-02
2.如果是jsp/servlet或struts1 要写一个字节碼转换的过滤器,struts2就免了(内部的拦截器给实现了)