sqlStmt = sqlCon.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,
java.sql.ResultSet.CONCUR_READ_ONLY); 这句应该不是产生乱码的地方,中文乱码的解决方案多的是,看哪个同你的相近,再看具体问题具体解决吧
java.sql.ResultSet.CONCUR_READ_ONLY); 这句应该不是产生乱码的地方,中文乱码的解决方案多的是,看哪个同你的相近,再看具体问题具体解决吧
解决方案 »
- Spring Ioc注入setter问题
- 小弟有个问题困扰了很久。请大家来帮帮忙
- web项目中实例化对象不消失问题(静态变量)询问
- 新手servlet问题,为什么报java.util.MissingResourceException
- jsp分页问题?
- struts 的actionForm 执行validate 返回原来页面后原来的值无法获得,即页面不显示任何信息
- 我想在98下装JSP环境?这里该下哪个?
- 还是有关TOMCAT+IIS整合的问题,都来看看吧!!!(在线急等)
- javax.servlet.ServletException: Io 异常: The Network Adapter could not establish the connection
- 项目中访问路径写绝对路径合适还是写相对路径合适
- applet间怎样通讯??
- 急求 怎样处理jsp分页问题, 在线等 急急急!!!
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<%@ page contentType="text/html;charset=gb2312" %>
<% request.setCharacterEncoding("GB2312");%>
而且用sqlStmt = sqlCon.createStatement(); 就能正常显示,
用sqlCon.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,
java.sql.ResultSet.CONCUR_READ_ONLY);
就不行!到底是为什么啊?!!!
情大家帮帮我!
<%@ page import="java.sql.*"%>
<%
int pagesize=2;//每页显示记录数
int recordcount=0;//记录总数
int pagecount=0;//总页数
int pageid=1;//待显页码
Connection conn=null;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn=DriverManager.getConnection("jdbc:odbc:jspguest","sa","sa");
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
//String name=request.getParameter("name");
//String pwd=request.getParameter("pwd");
//String sql="select * from system where adminname like '%"+name+"%' and name like '%"+pwd+"%' order by user_id desc";
String sql="select * from message";
ResultSet rs=stmt.executeQuery(sql);
rs.last();
recordcount=rs.getRow();//取得总记录数
pagecount=(recordcount%pagesize==0?(recordcount/pagesize):(recordcount/pagesize)+1);//取得总页数
int count=1;
String strpage=request.getParameter("pageid");
if(strpage==null) pageid=1;
else pageid=Integer.parseInt(strpage);
if(pageid>recordcount) pageid=recordcount;
if(recordcount>0){
rs.absolute((pageid-1)*pagesize+1);}
int i=0;
//rs.previous();
rs.beforeFirst();
while(rs.next()&&count<=pagesize){
count++;
i++;
out.print(rs.getString("name"));
out.print("||");
out.print(rs.getString("title"));
out.print("<br>");
}
out.print("共");
out.print(pagecount);
out.print("页");
out.print("共");
out.print(recordcount);
out.print("条");
out.print("第");
out.print(pageid);
out.print("页");
out.print("<br>");
if(pageid<pagecount){
out.print("<a href=del.jsp?pageid=");
out.print(pageid+1);
out.print(">下一页</a>");}
if(pageid>1){
out.print("<a href=del.jsp?pageid=");
out.print(pageid-1);
out.print(">上一页</a>");}
out.print("<br>");
for(int j=1;j<=pagecount;j++){
out.print("<a href=del.jsp?pageid=");
out.print(j);
out.print(">");
out.print(j);
out.print("</a>");}
stmt.close();
conn.close();
}
catch(ClassNotFoundException e){
out.println(e.getMessage());
}
catch(SQLException e) {
out.println(e.getMessage());
}
finally{
try{
if(conn != null)
conn.close();
}
catch(Exception e){}
}
%>