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);
Statement stmt = conn.createStatement();
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) {
System.out.println("MySql操作错误");
e.printStackTrace();
}catch (Exception e) {
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`