本文共 1437 字,大约阅读时间需要 4 分钟。
也是借的同学的笔记,免费培训时候的。(2009-6-25)
* == 通配
----添加
Insert into student (STUDENTNO, STUDENTNAME,STUDENTSEX,STUDENTMAJOR,STUDENTGRADE,STUDENTADDRESS,……)
Values (6,’caicai’,’女’,……)
Insert into 表名(表的字段) values(表的字段对应的数据)
----修改
Update student set STUDENTNAME=’ceshi’ where STUDENTNO=5
Update 表名 set 要修改的字段=数据 where 条件
----删除
Delete student where STUDENTNO=5
select * from student t 查询
select STUDENT,STUDENTNAME,STUDENTSEX from student
insert into student (STUDENTNO, STUDENTNAME,STUDENTSEX,STUDENTMAJOR,STUDENTGRADE,STUDENTEMAIL,STUDENTADDRESS,STUDENTMOBIEL,STUDENTREGISTDATE)
Values (6,'caicai','女','泡GG专业','大1','caicai@163.com','中信','1314520','2008/08/08')
insert into student (STUDENTNO, STUDENTNAME,STUDENTSEX,STUDENTMAJOR,STUDENTGRADE,STUDENTEMAIL,STUDENTADDRESS,STUDENTMOBIEL,STUDENTREGISTDATE)
Values (7,'caicai','女','泡GG专业','大1','caicai@163.com','中信','1314520','2008/08/08')
update student set STUDENTNAME='ceshi' where STUDENTNO=6
delete student where STUDENTNO=7
使用第三方组建:将D:/oracle/ora92/jdbc/lib中的classes12.jar添加入新建的lib文件夹中(在工程中新建),
右键该工程名查看属性,选Libraries标签,添加jars。
TestJDBC
1、 加载oracle驱动
Try {
Class.forName(“”);
}
2、 通过驱动管理器类来建立数据库链接,返回一个链接对象
Connection con = DriverManager……
3、 通过链接对象创建并执行sql语句的对象
Statement st = con.createStatement();
String sql = “select STUDENTNO,STUDENTNAME<STUDENTSEX from student”;
4、通过sql语句的对象执行sql,返回结果放置在ResultSet对象中
ResultSet rs = st.executeQuery(sql);
循环
While (rs.next()){
System.out.println(rs.get):
}
s
转载地址:http://cyxbi.baihongyu.com/