JAVA项目连接到JDBC

public class JDBCTest { public static void main(String[] args) throws Exception { Connection conn = null; String sql; String url = "jdbc:mysql://localhost:3306/test?user=root&password=123456&useUnicode=true&characterEncoding=UTF-8"; try { Class.forName("com.mysql.jdbc.Driver"); System.out.println("成功加载mysql程序"); conn = DriverManager.getConnection(url); //一个connection代表一个连接 Statement stmt = conn.createStatement(); //Statement里面带有很多方法，比如executeUpdate可以实现插入、更新和删除等 // sql = "drop table if exists student"; // int result = stmt .executeUpdate(sql); // if(result!= -1) // { // System.out.println("student表已存在，并且删除成功"); // } sql = "create table if not exists student(NO char(20) , name varchar(20) , primary key(NO))" ; int result = stmt.executeUpdate(sql); if (result != -1) { System.out.println("创建数据表成功"); sql = "insert into student(NO,name) values ('201703','赵丽颖')"; result = stmt.executeUpdate(sql); sql = "insert into student(NO,name) values ('201704','李易峰')"; result = stmt.executeUpdate(sql); sql = "select * from student"; ResultSet rs = stmt.executeQuery(sql); System.out.println("学号\t姓名"); while(rs.next()) { System.out.println(rs.getString(1)+"\t"+rs.getString(2)); } } } catch (SQLException e) { // TODO Auto-generated catch block System.out.println("MySql操作错误"); e.printStackTrace(); }catch (Exception e) { // TODO: handle exception e.printStackTrace(); }finally { conn.close(); } } } ***CMD操作数据库*** 1、以管理员身份进入cmd 2、mysql -u root -p 3、输入password 4、通过下面语句可以给usernyl用户赋予所有数据库链接的查询修改增加和删除的权限，或者通过test.*可以给该用户赋予test数据库链接的权限 `grant select,insert,update,delete on *.* to usernyl@localhost identified by "passwordnyl";` 5、`show databases`显示所有数据库连接 6、`use database`通过use进入到某个数据库连接 7、`shouw tables`显示该数据库连接中的所有table 8、接下来可以操作数据库`selct * from student`