java 连接mysql时用下面的连接方式:
Class.forName( "com.mysql.jdbc.Driver" );
//connection = DriverManager.getConnection( url, username, password );
Class.forName( "com.mysql.jdbc.Driver" );
//connection = DriverManager.getConnection( url, username, password );
this.connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/shop?user=root&password=&characterEncoding=utf-8"
可避免乱码
sql不用进行转码工作。
直接Statement.execute(sql);