jsp连接数据库大全.doc

jsp 连接数据库大全一、 jsp连接 Or acle8 /8i/9 i数据库 test oracl 如下: <%@ p age c onten tType ="tex t/htm l;cha rset= gb231 2"%> <%@ page impor t="ja l.*"% > <h tml> <bod y> < %Clas Name( "orac iver. Oracl eDriv er"). newIn stanc e(); Stri ngur l="jd bc:or acle: thin: ***@loca lhost :1521 :orcl "; / /orcl 为你的数据库的 SID Str ing u ser=" scott "; S tring pass word= "tige r"; Conne ction conn = Dri verMa nager .getC onnec tion( url,u ser,p asswo rd); Stat ement stmt =conn .crea teSta temen t(Res ultSe E_SCR OLL_S ENSIT IVE,R esult ONCUR _UPDA TABLE ); S tring sql= "sele ct* from test" ; Re sultS et rs =stmt .exec uteQu ery(s ql); whil e(rs. next( )) {% >您的第一个字段内容为: < %=rs. getSt ring( 1)%> 您的第二个字段内容为: <%= tStri ng(2) %> < %}%> <%ou nt(" 数据库操作成功,恭喜你");%> <%r se(); stm se(); con se(); %> </bo dy> </htm l>二、 jsp 连接 Sql Serve / 2000 数据库 t estsq lserv p如下: <%@ page conte ntTyp e="te xt/ht ml;ch arset =gb23 12"%> <%@ page impo rt="j ql.*" %> < html> <bo dy> <%Cla rName ("com .micr osoft .jdbc .sqls erver .SQLS erver Drive r").n ewIns tance (); Strin g url ="jdb c:mic rosof t:sql serve r://l ocalh ost:1 433;D ataba seNam e=pub s"; //pub s为你的数据库的 Strin g use r="sa ";S tring pass word= ""; Conne ction conn = Dri verMa nager .getC onnec tion( url,u ser,p asswo rd); Stat ement stmt =conn .crea teSta temen t(Res ultSe t.