学步园

一. Statement和PreparedStatement的使用

      以insert语句，就是将从控制台输入进来的数据存入数据库

      1. 使用Statement：

String sql = "insert into toperator(operatorid,operatorname,operatorpwd,isadmin)values('"+args[0]+"','"+args[1]+"','"+args[2]+"','"+args[3]+"')";<br /> Statement stmt = conn.createStatement();<br /> stmt.executeQuery(sql);

      2.  使用

PreparedStatement pstmt = null;<br /> pstmt = conn.prepareStatement("insert into toperator(operatorid,operatorname,operatorpwd,isadmin)values(?,?,?,?)");<br /> pstmt.setString(1, args[0]);<br /> pstmt.setString(2, args[1]);<br /> pstmt.setString(3, args[2]);<br /> pstmt.setString(4, args[3]);<br /> pstmt.executeUpdate();

Ps：这里很重要一点：在控制台直接操作数据库时需要在每一个语句之后加“；”，而在程序中控制时，“；”需要被省略

create or replace procedure pppp<br /> (v_a in number,v_b in number,v_ret out number,v_temp in out number)<br /> is</p> <p>begin<br /> if(v_a>v_b) then<br /> v_ret := v_a;<br /> else<br /> v_ret := v_b;<br /> end if;<br /> v_temp := v_temp+1;<br /> end;

二. 调用存储过程,这当中使用到了CallableStatement

存储过程语句：

java程序中要到的相关语句：

CallableStatement cstmt = conn.prepareCall("{call p(?,?,?,?)}");<br /> cstmt.registerOutParameter(3, Types.INTEGER);<br /> cstmt.registerOutParameter(4, Types.INTEGER);<br /> cstmt.setInt(1, 3);<br /> cstmt.setInt(2, 6);<br /> cstmt.setInt(4, 6);<br /> cstmt.execute();<br /> System.out.println(cstmt.getInt(3));<br /> System.out.println(cstmt.getInt(4));

三.  批处理

stmt = conn.createStatement();<br /> stmt.addBatch("insert into toperator(operatorid,operatorname,operatorpwd,isadmin) values('A'||toperator_seq.nextval,'mick','12390','Y')");<br /> stmt.addBatch("insert into toperator(operatorid,operatorname,operatorpwd,isadmin) values('A'||toperator_seq.nextval,'Tina','72390','Y')");<br /> stmt.addBatch("insert into toperator(operatorid,operatorname,operatorpwd,isadmin) values('A'||toperator_seq.nextval,'rose','74902','Y')");<br /> stmt.executeBatch();

四.  保存数据完整性：

conn.setAutoCommit(false);<br /> stmt = conn.createStatement();<br /> stmt.addBatch("insert into toperator(operatorid,operatorname,operatorpwd,isadmin) values('A'||toperator_seq.nextval,'mick','12390','Y')");<br /> stmt.addBatch("insert into toperator(operatorid,operatorname,operatorpwd,isadmin) values('A'||toperator_seq.nextval,'Tina','72390','Y')");<br /> stmt.addBatch("insert into toperator(operatorid,operatorname,operatorpwd,isadmin) values('A'||toperator_seq.nextval,'rose','74902','Y')");<br /> stmt.executeBatch();<br /> conn.commit();<br /> conn.setAutoCommit(true);

五.  可滚动的结果集

//实现代码<br /> stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);//这个功能的主要代码<br /> rs = stmt.executeQuery("select * from toperator order by operatorid");//执行SQL语句，获得结果集<br /> //检查代码：<br /> rs.next();<br /> System.out.println(rs.isFirst());<br /> rs.last();<br /> System.out.println(rs.isLast());<br /> rs.absolute(5);<br /> System.out.println(rs.getString(2));