将
catch(UnsupportedEncodingException e)
换成:
catch(java.io.UnsupportedEncodingException e)试试看
catch(UnsupportedEncodingException e)
换成:
catch(java.io.UnsupportedEncodingException e)试试看
解决方案 »
- java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver怎么解决?
- 求一SQL语句:论坛中有时间字段格式如:2006-11-16 14:11:32 如何实现查询本周帖子?!多谢!
- 100分,求JSP视频教程!急!!!!!!!!!!!!!!!!!1
- 程序没问题,简单的applet程序为什么在win2K下能显示,在xp系统下就不能显示了,为什么?
- 用过stuts-menu的请进
- session取值取不到的问题?求解啊
- 送分的问题(大家看看like)
- 字符串格式问题,在线等待,解决即给分
- 乱码,郁闷????(全给,100 分)
- jb7下运行servlet该怎样配置?
- 哪位高手来帮帮我啊,JAVA插入记录到ACCESS的正确格式是怎么样的啊?
- 这是为什么????!!!
catch(UnsupportedEncodingException e)
换成:
catch(java.io.UnsupportedEncodingException e)
但是,可以显示了,不过中文部分显示的还是????
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head><body>
以下是从Ms sql server数据库读取的数据:<hr>
<table border=1><%! String trans(String chi)
{
String result = null;
byte temp [];
try
{
temp=chi.getBytes("iso8859_1");
result = new String(temp);
}
catch(java.io.UnsupportedEncodingException e)
{
System.out.println (e.toString());
}
return result;
}
%>
<% Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
Connection con=java.sql.DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=jck;charset=gb2312","sa","123");
Statement stmt=con.createStatement();
ResultSet rst=stmt.executeQuery("select * from bbs_news;");
while(rst.next())
{
out.println("<tr>");
out.println("<td>"+trans(rst.getString("title"))+"</td>");
out.println("<td>"+trans(rst.getString("times"))+"</td>");
//out.println("<td>"+trans(rst.getString("bj"))+"</td>");
//out.println("<td>"+rst.getFloat("bjrs")+"</td>");
out.println("</tr>");
}
rst.close();
stmt.close();
con.close();
%>
</table></body>
</html>
while(rst.next())
{
out.println("<tr>");
out.println("<td>"+trans(rst.getString("title"))+"</td>");
out.println("<td>"+trans(rst.getString("times"))+"</td>");
//out.println("<td>"+trans(rst.getString("bj"))+"</td>");
//out.println("<td>"+rst.getFloat("bjrs")+"</td>");
out.println("</tr>");
}
换成:
while(rst.next())
{
out.println("<tr>");
out.println("<td>"+rst.getString("title")+"</td>");
out.println("<td>"+rst.getString("times")+"</td>");
//out.println("<td>"+trans(rst.getString("bj"))+"</td>");
//out.println("<td>"+rst.getFloat("bjrs")+"</td>");
out.println("</tr>");
}
<%@ page language="java" errorPage="../Styles/ErrorPage.jsp" %>
trans(rst.getString("title"))象这条语句是错误的,不应该转换,去掉trans()这个方法!
直接写成rst.getString("title")就可以了!
你把catch(java.io.UnsupportedEncodingException e)
改成catch(java.io.Exception e)试一试
代码如下:
-------------------------------------------------------
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head><body>
以下是从Ms sql server数据库读取的数据:<hr>
<table border=1>
<% Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
Connection con=java.sql.DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=jck;charset=gb2312","sa","123");
Statement stmt=con.createStatement();
ResultSet rst=stmt.executeQuery("select * from bbs_news;");
while(rst.next())
{
out.println("<tr>");
out.println("<td>"+rst.getString("title")+"</td>");
out.println("<td>"+rst.getString("times")+"</td>");
//out.println("<td>"+trans(rst.getString("bj"))+"</td>");
//out.println("<td>"+rst.getFloat("bjrs")+"</td>");
out.println("</tr>");
} rst.close();
stmt.close();
con.close();
%>
</table></body>
</html>