java access 连接编码

Question

java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Microsoft Jet ??ݿ??????Ҳ??????????ѯ 'keys'?? ȷ?????Ƿ???ڣ??Լ??????Ƶ?ƴд?Ƿ???ȷ??

 String url = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=d:\temp\gzjiapei.mdb";

我的项目是utf8

我把项目换成GBK 就可以了
连接的时候怎么指定连接编码

Answer 1

网上是这样教的,我也刚学到:

Properties prop = new Properties();
prop.put("charSet", "gb2312"); // 这里是解决中文乱码
prop.put("user", "");
prop.put("Password", "");
		
String url = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=2333.mdb";

...

Connection conn = DriverManager.getConnection(url, prop);