完成mysql和mysql-front的安装和环境变量的配置。
完成数据表的创建。
实现对数据库表的查询。
创建一个新表,对表的添加操作 :
Statement stmt = conn.createStatement();
int rtn=stmt.executeUpdate("insert into huiyuan(name,age,xingbie)values('zoey','19','女')");
int rtn=stmt.executeUpdate("insert into huiyuan(name,age,xingbie)values('leo','20','男')");
int rtn=stmt.executeUpdate("insert into huiyuan(name,age,xingbie)values('hervert','16','男')");
int rtn=stmt.executeUpdate("insert into huiyuan(name,age,xingbie)values('jane','18','女')");
修改操作: Statement stmt = conn.createStatement();
int rtn=stmt.executeUpdate("update huiyuan set name='alina' where name='jane'");
删除操作:Statement stmt = conn.createStatement();
int rtn=stmt.executeUpdate("delete huiyuan where name='leo'");