statement要点
来源:互联网 发布:告白夫妇网络漫画 编辑:程序博客网 时间:2024/06/17 13:24
使用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();//结果集的最后面
建表
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();//结果集的最后面
阅读全文
0 0
- statement要点
- JDBC要点总结、SQL注入示例(Statement和PreparedStatement)
- - Statement
- statement
- Statement
- statement
- statement
- statement
- 要点
- 要点
- Statement、Prepared Statement 和Callable Statement
- java statement
- 接口 Statement
- Statement(1)
- Statement 对象
- Statement (2)
- Statement (3)
- Job Statement
- 【JZOJ4427/HNOI2016模拟】 Alphadog
- 【机器学习杂货铺】——样本不平衡(暂缺)
- 【GDKOI2012模拟02.01】探险(最短路&&SPFA)
- java中的内部类总结
- 四大经典卷积网络介绍
- statement要点
- 有符号变量与无符号变量的值的转换
- 优先队列(二叉堆)
- nw.js(node-webkit) node-serialport的替代方案
- Codeforces Round #424 (Div. 1, rated, based on VK Cup Finals) C. Bamboo Partition(数学)
- 并发实战——并发相关知识点overview
- 南师附中集训 七日游(划掉)总结
- android控件12--ScrollView
- npm link的基本用法及实例