在MYECLIPSE中使用Java连接MySQL数据
导入外部包
Build Path ——>Configure Build Path…——>Add External JARs..public static void main(){
String url = “jdbc:mysql://127.0.0.1:3306/bankmananger”;
String username = “root”;
String password = “mysql”;
//2.加载驱动
Class.forName(“com.mysql.jdbc.Driver”);
//3.建立连接
DriverManager.getConnect(url,username,password);
//测试插入数据
PreparedStatement preparedStatement = connection.prepareStatement(“insert into user(userid,username,money)values(?,?,?);”);
preparedStatement.setString(1, “1110”);
preparedStatement.setString(2, new String(“陈九”));
preparedStatement.setString(3, “656666”);
int result = preparedStatement.executeUpdate();
System.out.println(result);
preparedStatement.close();
connection.close();
}
在数据库中出现中文乱码,在url后面追加?useUnicode=true&characterEncoding=utf-8使中文能够输入到数据库
String url = “jdbc:mysql://127.0.0.1:3306/bankmananger”;
改为:String url = “jdbc:mysql://127.0.0.1:3306/bankmananger?useUnicode=true&characterEncoding=utf-8”;
再次运行测试