jdbc笔记心得

CallableStatement:     存储过程
建立一个存储过程
create table sun_student(
id number(4) primary key,
name varchar2(20),
age      number(20),
sex       char
);
/****************************************************************
create or replace procedure insert_sun(
v_id  number,
v_name varchar2,
v_age number,
v_sex char
)
is
begin
insert into sun_student (id,name,age,sex)
values (v_id,v_name,v_age,v_sex);
commit;
end;
执行
exec insert_sun(1,'perter',20,'M');
/****************************************************************
create or replace procedure insert_sun1(
v_deptno  emp.deptno%type,
v_count out  number
)
is
begin
select count(*) into v_count
from emp where deptno=v_deptno;
commit;
end;

匿名块
set serveroutput on //打开sqlplus的开关
declare
v_count  number;
begin
insert_sun1(20,v_count);
dbms_output.put_line(v_count);
end;
/
/***************************************************************************
二，sql语句的批处理   （(批量处理)
B:business
C:customer
B2B： 阿里巴巴
B2C: 360buy.com ,当当，卓越，凡客
C2C: taobao
autoexec.bat
String sql1=".........";
String sql2=".........";
//conn.autoCommit(false);
//stmt.addBatch();
//stmt.executeBatch();
//conn.commit();
优化操作
create table mytemp(
id number primary key,
name varchar2(50)
)
增加到批处理缓存中的语句，可以隔一段
就执行，这样提高效率

--mysql
create table student(
id number primary key auto_incremnet,
name varchar2(20)
);
insert into student(name) values('petpr');
select * from student;
-----------------------------------------
序列实现自动增长的功能
create sequence myseq
start with 1000 increment by 10;
insert into mystu(id ,name,age,sex)
values (myseq.nextval,'chris',20,'M');

四.连接池
                     open                sql
connection  <->statement  <->resultset
                     close

tomcat:apache
weblogic : bea(oracle)

websphere: ibm
Oracle <---------------> Google
(sun) 开源机构 android
jdk harmony java

jdk+tomcat+mysql