OracleJDBC增刪改查(精)

1、Oracle + JDBC +增刪改查數(shù)據(jù)庫：ORACLE 10GMyEclipse : 6.5驅(qū)動：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側(cè)】 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部分代碼驅(qū)動連接package ;import java.sql.C onn ecti on; import java.sql.DriverMa nager;import java.sql.SQLExc

3、eptio n;public class DBconnection 刖據(jù) E 查找貝 I駅衣諭更人赳名查詢更新遙密據(jù)口州円駆憩據(jù)禪犯工二呂字丫限秋曙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;實現(xiàn)類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.