增加
//增加
String sql1 = "insert into hero values(8,'hao',10,6)";
s.execute(sql1);
//往里面增加一堆,方便删除
for(int i = 9;i <= 30;i++) {
String sql = "insert into hero values(null, "+" '英雄" +i+"'"+","+313.0f+","+50+")";
s.execute(sql);
}
//备注 上下两个增加sql语句一起运行,会报错
修改
//修改
String sql = "update hero set name = '韦小宝' where id = 3";
s.execute(sql);
删除
//删除
String sql = "delete from hero where id = 8";
s.execute(sql);
查询
//查询
//executeQuery 执行SQL查询语句
String sql =</