Java uses jdbc to connect to the access database-garbled characters are displayed in Chinese (fixed) and jdbcaccess
Scenario: The following prompt is garbled before the problem is resolved.Java. SQL. SQLException : [Microsoft] [ODBC Microsoft Access driver] '(unknown)' is not a valid path. Check whether the path name is correctly spelled and whether it is connected to the server where the file is stored..
I have tried this solution. For details, see his blog http://blog.csdn.net/iamoyjj/article/details/5805327,but it is ineffective.
Later, my company's experts found the following solution: Properties prop = new Properties (); prop. put ("charSet", "gbk"); prop. put ("user", "user Name"); prop. put ("password", "password"); Connection conn = DriverManager. getConnection (dbur1, prop );
Note: This is the connected remote server.
I tried it very effectively. I like it!The company is very nice and happy, so I thought of sharing this thing with everyone. Thank you!