JDBC操作Oracle數(shù)據(jù)庫增刪改查詳細(xì)實例教程

1、private finalStri ng = "oracle.jdbc.driver.OracleDriver"及登錄；功能實現(xiàn)。Ecli pse + Struts2+oracle+jdbceb開發(fā)技術(shù)框架入門小項目，一般都是從增刪改功能實現(xiàn)開始入手，就像學(xué)編程語言幾乎從“HelloWorld fin al” 一樣的經(jīng)典，本人初入String = "jdbc:oracle:thi n: 9:1521:de nver"private final String DBUSER ="zzw"private final 一

2、、環(huán)境搭建"zzw"private Conn ection COnn = n ull;導(dǎo)入必要的包，我所建工程引入如下包:P ublic DataBaseC onn ecti on( C lasses12.jar com mon s-fileu pl oad-1.22jar com mon s-io-2.0.1.jar com mon s-la ng-2.5.jar freemarker- 2.3.16.jar javassist-3.11.0.GA.jar og nl-3.0.1.jar ojdbc14.jar struts-core-2.2.3.jar xwork-co

3、re-2.2.3.jartry 引入的包具體的版本同struts的版本有關(guān)系，我的是sturts2.26(DBDRIVER;this.conn = DriverManager. getConnection、DBURL, web.xml , DBP ASSWORD我的web.xml內(nèi)容如下: xml?>/取得數(shù)據(jù)庫連接web-appp ublic Conn ecti on getC onn ecti on( "xmlns=" return xmlns:web =" app_2_5.xsd" =" id="WebApp_ID &qu

4、ot; version=" close( " > try < dis play-name > / 我的工程名為 webDemo catch (Exce pti on e struts-default.xml,struts-plugi n.xmlstaticfilter >System.println(aa.getConnection(;< filter-mapping <filter-name > filter-name 測試類 Main .javaJavaurl-pattern >/* url-pattern >p a

5、ckage com.c onn ect.tO1;filter-ma ppingimport import < welcome-file-listimp ort /默認(rèn)顯示頁面import <welcome-file* desc>* jdbc>數(shù)據(jù)庫(welcome-file >default.html welcome-file >< 2013 -default.htm welcome-file*/<welcome-file > default.jspwelcome-fileSuppressWarnings (public staticmai

6、n(String args web-appPerson person =如果有不懂的地方，百度搜索一下 “perso n.setld("002"三、酉己置 p ers on. setName(通俗一點(diǎn)來書，本人覺得S就像一個導(dǎo)航，也是一個映射關(guān)系，頁面的跳轉(zhuǎn)，及動作的發(fā)生，都是struts.xml "002"，基本上struts的原理你就弄清楚了，所以本人重點(diǎn)講解一下自己所遇到的問題。（該文檔是最終文 檔，請對照自己的來理解。"eleve n"xmlen codi ng="UTF-8"?>通過工廠獲得實例ge

7、t Perso nDAOl nsta nce-/A pache Software Fou ndati on /DTD Struts Co nfiguration 2.0/EN"htt p:/struts.a /dtds/struts-2.0.dtdstruts><in clude/=" ps.insert(person; "> / System.out.println("插入數(shù)據(jù)庫成功"p ackage n ame=""/ struts-default "><acti

8、on namelog in " ClaSS=" actio n丄oginActio n " System.out. println(” </ catch (Exce ption e n ame=""> 登錄失敗，轉(zhuǎn)向loginfail.jspresult><result/name="success'>/登錄成功，轉(zhuǎn)向 loginsuccess.jsp/ / 根據(jù) >/ try /query.js p/ result/ < result name=" toADDNEWS &qu

9、ot;>/轉(zhuǎn)向增加功能的實現(xiàn)頁面/add.js p/ result/ /result name="/ ">/增加功能的頁面 e.printStackTrace(; result>模糊查詢try nameup date"/更新數(shù)據(jù)頁面/遍歷listSystemout. prin tl n(list.get(i.toStn ng(;>struts> acti onforSystemoutp ackage acti on;import java.sql.C onn ecti on;import java.sql.ResultSet;impo

10、rt java.sql.Statement; e.printStackTrace(;imp ort javax.servlet.htt p. Htt pSessi on;p ublic class Log in Acti on exte nds Acti onSupport 創(chuàng)建表的SQL語句:p rivate String username;drop table P ERSON cascade constraintscreate table P ERSONID VARCHAR2(20,NAME VARCHAR2(30,PASSWORD VARCHAR2(30,AGE INTEGER,EMAIL VARCHAR2(60 alter table P ERSON add constraint P ERSONID unique (ID;insert into P ERSON (ID, NAME, PASSWORD, AGE, EMAIL val