OracleJDBC增删改查(精)

1、Oracle + JDBC +增删改查数据库：ORACLE 10GMyEclipse : 6.5驱动：D:oracleproduct10.1.0db_1jdbclibocrs12.jar暑工弓 0 二媲屯JLW*O5*t 牺Tit | HPQ号ALLEX44t1*9 J 科.摹 i ttoo *_mM他JOMVu g1 时宦;J* Rwumx&AL&MAX Mi1W W 2RM L* M”溯B1AHUNAGa1WlW4s.Cr UNAGKr/JJJ. 412Th 3JklMirES 沁 4%山Wl側】 W _b_ -I jj JUWtUUCE*hLAXAul远习 共裔 0ja1

2、=LAXK】疝：比inti.iconAALVhT64 活MOlp 3屮-UtLsMA.%mi-iM-OI -sovpk iaTiADAMCLlMi11计JJ舸 Bx字理；MSXEtCtMim;3TOO|9M:MILLERUNA|.JSXLAAfclltig；RiMi idr* lALUy31 号 MA5 4 禅 F】理】巾；耗】3fl:m iatF It? UK3)1141 G 51：21132部分代码驱动连接package ;import java.sql.C onn ecti on; import java.sql.DriverMa nager;import java.sql.SQLExc

3、eptio n;public class DBconnection 刖据 E 查找貝 I駅衣谕更人赳名查询更新遥密据口州円駆憩据禅犯工二吕字丫限秋曙private static String url=jdbc:oracle:th in:localhost:1521:orcl;private static Stri ng user=scott;private static String password=tiger;private static Connection conn ecti on=n ull;public static Connection getC onn ecti on(try

4、Class.forName(oracle.jdbc.OracleDriver;conn ecti on=DriverMa nager.getCo nn ection( url,user,password;System.out.pri ntln (OK; catch (ClassNotF oun dExcepti on e / TODO Auto-ge nerated catch blocke.pri ntStackTrace(; catch (SQLExcepti on e / TODO Auto-ge nerated catch blocke.pri ntStackTrace(;retur

5、n conn ecti on;实现类package ;import java.sql.C onn ecti on;import java.sql.ResultSet;import java.sql.SQLExceptio n;import java.sql.Stateme nt;import java.util.ArrayList;import java.util.List;import com.baidu.vo.Myemp;public class TestJDBC1 private Stateme nt st;private ResultSet rs;private Connection

6、conn ecti on = DBconnection. getC onn ecti on(;List list = new ArrayList (;public List queryAll(Stri ng sql=select * from myemp;try st= conn ectio n.createStateme nt(;rs=st.executeQuery(sql;while(rs. next(Myemp emp = new Myemp(;emp.setEmp no (rs.get In t(emp no;emp.setE name(rs.getStri ng(e name;emp

7、.setJob(rs.getStri ng(job;emp.setMgr(rs.getI nt(mgr;emp.setHiredate(rs.getDate(hiredate;emp.setSal(rs.getl nt(sal;emp.setComm(rs.getI nt(comm;emp.setDept no (rs.get In t(dept no;list.add(emp; catch (SQLExcepti on e / TODO Auto-ge nerated catch blocke.pri ntStackTrace(;return list;SERVLETpackage com.

8、baidu.demo;import java.io .IO Exceptio n;import java.util.List;import javax.servlet.ServletExcepti on;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResp on se;import .TestJDBC1;import com.baidu.vo.Myemp;public class TestServle

9、t exte nds HttpServlet public void doGet(HttpServletRequest request, HttpServletResp onse resp onse throwsServletExcepti on, I OExcepti on doPost(request,resp on se;public void doPost(HttpServletRequest request, HttpServletResp onse resp onse throwsServletExcepti on, I OExcepti on TestJDBCI jdbc = n

10、ew TestJDBC1(;List list = jdbc.queryAII(;Stri ng url=/MyJsp.jsp;request.setAttribute(list, list;request.getRequestDispatcher(url.forward(request, resp on se;JSP页面v% page language=java import =java.util.* pageEncoding=UTF-8 %v% page import = com.baidu.vo.Myemp %DOCTYPE HTML PUBLIC -/W3C/DTD HTML 4.01 Transitional/ENbase href= My JSP MyJsp.