xampp中mysql中配置问题

运行xampp-win32- 1.5.5 -installer.exe,安装了xampp后,其自带的mysql5.0.27版的,安装一切正常,成功后访问数据库也没问题,在数据库操作一切也正常。

但我写了个简单的java程序访问数据库时,却出现了问题。原程序如下:

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

 

public class DAOTest {

    private static final String URL = "jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8";

 

    private static final String USERNAME = "root";

 

    private static final String PASSWORD = "root";

 

    private static final String DRIVER = "com.mysql.jdbc.Driver";

 

    public static Connection getConnection() {

       try {

           Class.forName(DRIVER);

           return DriverManager.getConnection(URL, USERNAME, PASSWORD);

       } catch (ClassNotFoundException ce) {

           throw new java.lang.RuntimeException(ce);

       } catch (SQLException se) {

           throw new java.lang.RuntimeException(se);

       }

    }

    public static void main(String[] args){

       Connection conn=getConnection();

       try{

           Statement stmt=conn.createStatement();

           ResultSet rs=stmt.executeQuery("select * from user");

           while(rs.next())

              System.out.println(rs.getString("username"));

       }catch(SQLException e){

           e.printStackTrace();

       }

    }

}

运行后问题如下:

Exception in thread "main" java.lang.RuntimeException: java.sql.SQLException: Unknown initial character set index '48' received from server. Initial client character set can be forced via the 'characterEncoding' property.

    at com.kemei.database.dao.DAOTest.getConnection(DAOTest.java:25)

    at com.kemei.database.dao.DAOTest.main(DAOTest.java:29)

Caused by: java.sql.SQLException: Unknown initial character set index '48' received from server. Initial client character set can be forced via the 'characterEncoding' property.

    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)

    at com.mysql.jdbc.Connection.configureClientCharacterSet(Connection.java:2345)

    at com.mysql.jdbc.Connection.initializePropsFromServer(Connection.java:3913)

    at com.mysql.jdbc.Connection.createNewIO(Connection.java:2683)

    at com.mysql.jdbc.Connection.<init>(Connection.java:1531)

    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)

    at java.sql.DriverManager.getConnection(DriverManager.java:525)

    at java.sql.DriverManager.getConnection(DriverManager.java:171)

    at com.kemei.database.dao.DAOTest.getConnection(DAOTest.java:21)

    ... 1 more

从错误的提示信息中发现字符集设置出现问题,于是想到可能是xampp自带mysql的配置文件可能出有问题。于是到mysql/bin目录下,找到my.cnf,打开该文件,把

collation-server = latin1_general_ci改为collation-server = latin1_swedish_ci,重启数据库,再运行该程序,问题解决。

 
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值