读取mysql中的中文数据问题

aboutagirl 2003-07-11 07:20:16

如果getConnection("jdbc:mysql://localhost/classmates","root","")，读出mysql中的中文数据显示为????，

如果改为getConnection("jdbc:mysql://localhost/mysql?user=root&password=&useUnicode=true&characterEncoding=8859_1")
则提示
java.sql.SQLException: General error: Incorrect database name 'mysql?user=root&password=&useUnicode=true&characterEncoding=8859_1'

为什么？

...全文

28 10 打赏收藏转发到动态举报

写回复

用AI写文章

10 条回复

切换为时间正序

请发表友善的回复…

发表回复

aboutagirl 2003-07-11

打赏
举报

源代码：
import java.sql.*;

public class db2
{
static public void main(String args[])
{
Connection conn = null;
Statement s = null;
ResultSet rs = null;
try
{
System.out.println("Loading JDBC driver .....");
DriverManager.registerDriver(new org.gjt.mm.mysql.Driver());
System.out.println("Loaded.");
try
{
System.out.println("\nConnecting to MySQL ......");
conn = DriverManager.getConnection("jdbc:mysql://localhost/mysql?useUnicode=true&characterEncoding=8859_1","root","");
System.out.println("Connected.");

try
{
System.out.println("\nCreating statement......");
s = conn.createStatement();
System.out.println("Created.");
try
{
System.out.println("\nCreating resultset......");
rs = s.executeQuery("select * from user");
System.out.println("Created.");
while (rs.next())
{
System.out.println("\n " + rs.getString(2));
}
}catch (Exception exce)
{
System.out.println("Failed.");
exce.printStackTrace();
}
}catch (Exception exc)
{
System.out.println("Failed.");
exc.printStackTrace();
}
}catch (Exception ex)
{
System.out.println("Failed !");
ex.printStackTrace();
}
}catch (Exception e)
{
System.out.println("Failed .");
e.printStackTrace();
}
finally
{
if (conn != null)
{
if (s != null)
{
if (rs != null)
{
try
{
System.out.println("\nClosing resultset......");
rs.close();
System.out.println("Closed.");
}catch (Exception eR)
{
System.out.println("Failed.");
}
}
try
{
System.out.println("\nClosing statement......");
s.close();
System.out.println("Closed.");
}catch (Exception eS)
{
System.out.println("Failed.");
}
}
try
{
System.out.println("\nClosing connection .....");
conn.close();
System.out.println("Closed.");
}catch (Exception exception)
{
System.out.println("Failed !");
exception.printStackTrace();
}
}
}
}
};

try语句太多：）

aboutagirl 2003-07-11