关键一句: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();
}
...
(详见
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();
}
...
解决方案 »
- ActionForm中Date类型属性的问题,求最佳方案
- 求助:关于strtus中form的问题,和消息文件问题。。
- jdbcTemplate调用存储过程的问题
- jxl使用问题,求教各位达人
- 关于java里面用getMethod调用方法的性能问题。
- 100分问:使用vb写的程序,通过xmlhttp上传给jsp文件,请问jsp如何接收?
- 请教一个servlet问题,关于弹出“保存”或“打开”对话框
- 我刚装了水晶报表9.2,但是并没有ras,是要什么advanced....版本么?
- 求教WEB页面的单元测试方法
- 再发:线程讨论......
- 请问这段访问数据库代码如何错了?
- 用JSP写入数据库出错,请高手指教,谢谢!
我的问题已解决,你的方法我早已试过,不管用。
mysql的text字段,应用new String(rs.getBytes("colname"),"gb2312");
就可以了。