代码:import java.sql.*;
public class conn
{
public static void main(String arg[])
{
try
{ Class.forName("org.gjt.mm.mysql.Driver"); Connection con=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/first1","root",""); Statement stmt = con.createStatement(); String sql = "SELECT * FROM first2"; ResultSet rs = stmt.executeQuery( sql );
String rs1;
while(rs.next())
{
for(int i=1;i<=3;i++)
{
rs1 = rs.getString(i);
System.out.print(rs1 + "\t");
}
System.out.println();
} rs.close();
stmt.close();
con.close(); }catch(ClassNotFoundException e)
{
System.out.println("错误:" + e);
}
catch(SQLException e)
{
System.out.println("错误:" + e);
}
}
}
结果:F:\code\java\mysql>java conn
1 ? ??
2 ?? ????
3 ?? ????
public class conn
{
public static void main(String arg[])
{
try
{ Class.forName("org.gjt.mm.mysql.Driver"); Connection con=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/first1","root",""); Statement stmt = con.createStatement(); String sql = "SELECT * FROM first2"; ResultSet rs = stmt.executeQuery( sql );
String rs1;
while(rs.next())
{
for(int i=1;i<=3;i++)
{
rs1 = rs.getString(i);
System.out.print(rs1 + "\t");
}
System.out.println();
} rs.close();
stmt.close();
con.close(); }catch(ClassNotFoundException e)
{
System.out.println("错误:" + e);
}
catch(SQLException e)
{
System.out.println("错误:" + e);
}
}
}
结果:F:\code\java\mysql>java conn
1 ? ??
2 ?? ????
3 ?? ????
id int(4)
name varchar(10) gbk_chinese_ci
pwd varchar(10) gbk_chinese_ci
好像是说加个什么编码格式什么什么的
jdbc:mysql://127.0.0.1:3306/first1?useUnicode=true&characterEncoding=GBK
我换个mysql看看吧。
谢谢。
首先得知道在数据库中存的是什么编码的字符,如果建字段没选字符集就用jdbc:mysql://127.0.0.1:3306/first1?useUnicode=true&characterEncoding=ISO8859-1读写,这样读出来的字符就ISO8859-1编码 public static String iso2Gb(String Str)
{
String str = null;
try{
str = new String(Str.getBytes("8859_1"),"GBK");
}catch(Exception e){}
return str;
}