关键一句:characterEncoding=gb2312
(详见
http://www.csdn.net/expert/topic/648/648994.xml?temp=.5069849)sConnStr="jdbc:mysql://wcsz/forums?user=walksing&[email protected]&useUnicode=true&characterEncoding=gb2312";import java.sql.*;
String sDBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
sDBDriver="org.gjt.mm.mysql.Driver";
//sDBDriver = "com.inet.tds.TdsDriver";
String sConnStr = "jdbc:odbc:jbbs";
//sConnStr="jdbc:inetdae:wcsz?sql7=true";
   try
   {
   Class.forName(sDBDriver);    }
   catch(java.lang.ClassNotFoundException ae)
   {
   System.err.println("ae:"+ae.getMessage());
   }
    
// sConnStr="jdbc:mysql://wcsz/forums?user=walksing&[email protected]&useUnicode=true&characterEncoding=gb2312";
Connection con =null;
 
Statement stmt;

try
{ con = DriverManager.getConnection(sConnStr);
   //Statement stmt = con.createStatement();
stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
//stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); 
String sql ="select * from [board]";
//sql ="select * from addressbook";
ResultSet srs = stmt.executeQuery(sql);
srs.absolute(1);
srs.relative(10);
System.out.println("after last?" +srs.isAfterLast());
int rowNum;
if(!srs.isAfterLast())
{
String name=srs.getString("boardname");
System.out.println(name+" "+"boardname");

}

//srs.afterLast();

while(srs.previous())
{
System.out.print("after last?" +srs.isAfterLast());
rowNum =srs.getRow();
System.out.print(rowNum);
System.out.print("rowNum");
String name=srs.getString("boardname");
System.out.println(name+" "+"boardname");
}
System.out.print("after last?" +srs.isAfterLast());
rowNum =srs.getRow();
System.out.println(rowNum);
srs.close();
stmt.close();
con.close();

}
...