课堂笔记课件

1、1.利用ement制作1.利用ement制作import java.sql.Connection; importjava.sql.DriverManager; import java.sql.ResultSet;importimport/1.利用publicclassZuoYe_1icvoidexec(Stringsql)throws Stringurl=jdbc:oracle:thin:localhost:1521:orcl; /主协议:子协议:瘦客户Connectionconn= ement()方法 创建一个 Sement 对象 stmt类型为Sement stmt = conn.crea

2、teS/stmt的execute方法可以让oracle执行sql语句返回值bb= /创建结果集对象rs接收stmt被执行后的结果ResultSet rs = stmt.getResultSet();ResultSetMetaDatarsmdrs.getMetaData(); /从结果集中获得结果集元数countrsmd.getColumnCount(/从元数据中获得列fori1i = count;irows = stmt.getUpdateCount(); 2import java.sql.Connection; import2import java.sql.Connection; impor

3、tjava.sql.DriverManager; import java.sql.ResultSet;importimport/2演示出注publicclassZuoYe_2icvoidread(Stringename) throwsStringConnectionconn= ementstmt=String sql=select*fromemp whereename/让oracle数据库sql语ResultSetrs=ResultSetMetaDatarsmd=count=fori= 1;i =count;i+)的对象publicicvoidmain(Stringargs) throwsEx

4、ceptionexec(select*from3.利用ement制作3.利用ement制作import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedSimport java.sql.ResultSet;importimportimport/3.利用publicclassZuoYe_3icvoidempno,Stringename,Stringmgr,Datehiredate,sal, doubledeptno)throwsStringurlConnectionconn= Stringsq

5、loempvalues(?,?,?,?,?,?,?,?); /?ement ps = conn.prepareS(1, empno);ps.setString(2,ename); ps.setString(3, job); (4, mgr);ps.setDate(5, new java.sql.Date(hiredate.getTime();publicicvoidmain(Stringargs) throwsExceptionread(1or1=1orename=ps.setDouble(6, sal); ps.setDouble(7,comm); ps.setDouble(6, sal);

6、 ps.setDouble(7,comm); (8, deptno);rows = ps.getUpdateCount();icvoidempno)throwsStringurlConnectionconn=DriverManager.getConnection(url,scott,Stringsql= delete from empwhere/预处理操作对象ementps =(1, rows = ps.getUpdateCount(); icvoidsal, doubledeptno)throwsStringurlConnectionconn= StringsqlStringsql=upda

7、teempm=?,deptno=?whereementps =ps.setString(1,ename); ps.setString(2, job); (3, mgr);ps.setDate(4, new java.sql.Date(hiredate.getTime();ps.setDouble(5, sal); ps.setDouble(6,comm); (7, deptno);(8, rows = ps.getUpdateCount();icvoidread(Stringename) throwsStringConnectionconn= String sql=select*fromemp

8、 whereenameement ps =conn.prepareSps.setString(1, ename);/让oracle数据库sql语ResultSetrs=ResultSetMetaDatarsmd=4.5.例化34.5.例化3值/5为世界上所有的宠物定义一个类。法。并实例化3个宠物出来，给属性赋publicclass String nickName;String strain;health/健康lovevoid 水杯属性 容量 密封性 方法count=fori= 1;i =count;i+)的对象publicicvoidmain(Stringargs) throwsException,MANAGER,7788,newDatedate=newDate(); publicicpublicicvoidmain(Stringargs) Pet dog