statement要点

使用statement 执行 DDL
建表
String sql = "create table student (id int ,name varchar(20),age int)";
statement stat = conn.createStatement();
stat.execute(sql);  //注意


使用statement 执行 DML
更新
Insert


String sql = "insert into student (id,name,age) values (1,'tom',20)";
statement stat = conn.createStatement();
stat.executeUpdate(sql); //注意


Update
String sql = "update student set name='kit' where id=1";


delete
String sql = "delete from student where id = 1";


查找
select
String sql = "select * from student";
statement stat = conn.createStatement();
ResultSet rs = stat.executeQuery(sql);  //注意


//结果集 数据库查询的记录
while(rs.next()){
int id;
String name;
int age;


id = rs.getInt("id");
name = rs.getString(2);
age = rs.getInt(3);
System.out.println(id+" "+name + " "+age);
}


rs.afterLast(); //结果集的最前面
rs.beforeFirst();//结果集的最后面