JSP2天課件CS1、CS=客戶端2CS3、CS己變成一個(gè)名.exe.com4javaCSmain函數(shù)直接運(yùn)行的程序publicstaticvoidmain(String[]二、JDBCOracle1NetManager2Oraclejar3jdbcvoidvoidConnectionconn=null;try{Stringurl="jdbc:oracle:thin:@pc201:1521:orcl";Stringusername="studsys";Stringpassword="orcl";System.out.println("數(shù)據(jù)庫(kù)連接建立成功?。。?);}catch(Exceptione)}try{}catch(SQLExceptione)//TODOAuto-generatedcatchblock}}}1jdbcinsertinto 'test','學(xué)生'2Stringsql=”insertinto數(shù)據(jù)表values（intvoidvoidConnectionconn=null;try{Stringurl="jdbc:oracle:thin:@pc201:1521:orcl";Stringusername="studsys";Stringpassword="orcl";System.out.println("數(shù)據(jù)庫(kù)連接建立成功?。。?);Statement Stringsql="insertintoUSER_REGvalues('aTest2','檢測(cè)','test','學(xué)生')"; int //affected:受影響的number: int }catch(Exceptione){}try{}catch(SQLExceptione)//TODOAuto-generatedcatchblock}}}}Statement改',user_type='講師where Stringsql="updateUSER_REGsetname='檢測(cè)改改', '";intan=stmt.executeUpdate(sql);Statement Stringsql="deletefromUSER_REGwhereuser_id='aTest2'";Stringsql="deletefromUSER_REG"; Stringsql="deletefromUSER_REGwhereuser_type='學(xué)生 Stringsql="deletefromUSER_REGwhereuser_type='講師intan=stmt.executeUpdate(sql);2sql語(yǔ)句不同0StatementStringsql="createtableuser_Reg_A( USER_IDintprimarykey,"+"NAMEvarchar2(20),"+"PASSWORDvarchar2(20)"+")";intan=stmt.executeUpdate(sql);1sql語(yǔ)句不同StatementStringsql="droptableuser_Reg_Aintan=stmt.executeUpdate(sql);12個(gè)要素是數(shù)據(jù)的數(shù)據(jù)類型ResultSet對(duì)象中2Statement Stringsql="select* fromstudent"; 號(hào)ResultSetResultSetMetaDatameta=rs.getMetaData();intfieldNum=meta.getColumnCount();for(inti=0;i<fieldNum;i++){StringfieldName=meta.getColumnName(i+1);StringfieldType=meta.getColumnTypeName(i+1);}1均可以用字符串替代Stringsql="select* fromstudent"; ResultSetrs=stmt.executeQuery(sql);booleanisOK;intno=0;StringintstudId2=rs.getInt("stud_id");//字段原有數(shù)據(jù)類型INTStringname=rs.getString("name");Stringintage2=rs.getInt("age")字段原有數(shù)據(jù)類型intString 類型}十一、jdbc2、jdbc操作需要向數(shù)據(jù)庫(kù)服務(wù)器申請(qǐng)相應(yīng)數(shù)量的內(nèi)存所以上面3個(gè)關(guān)閉，是關(guān)閉服務(wù)器申請(qǐng)的內(nèi)存十二、JDBCtry/catch/finally1finallyvoidtestvoidtest()Connection try{Stringurl="jdbc:oracle:thin:@pc201:1521:orcl";Stringusername="studsys";Stringpassword="orcl"; Statementstmt=conn.createStatement();Stringsql="select* fromstudent"; ResultSetrs=stmt.executeQuery(sql);booleanisOK;intno=0;StringintstudId2=rs.getInt("stud_id");//字段原有數(shù)據(jù)類型Stringname=rs.getString("name");Stringage1=rs.getString("age");intage2=rs.getInt("age")字段原有數(shù)據(jù)類型String 類型}System.out.println("}catch(Exceptione){}finally try{}catch(SQLExceptione)//TODOAuto-generatedcatchblock}}}十三、JDBC－StatementCRUD操作2jdbc工作有固定的框架jdbc3try/catch/finally4jdbcjar十四、PreparedStaStatement sql處理工2jdbcsql語(yǔ)句送入數(shù)據(jù)庫(kù)服務(wù)器，執(zhí)行編繹操作，形成可以調(diào)用的函數(shù)sql語(yǔ)句，得到數(shù)據(jù)庫(kù)的執(zhí)行結(jié)果。3Stringsql="select*fromuser_reg";PreparedStatementResultSetrs=pstmt.executeQuery(); booleancheck;intno=0;StringuserId=rs.getString(1);Stringname=rs.getString(2);Stringpwd=rs.getString(3);String System.out.println(no++);//顯示從0}十五、PreparedStatement1PreparedStatementN1Stringsql="select*fromuser_regwhereuser_type=?anduser_idlike?";PreparedStatementpstmt.setString(1,"學(xué)生");pstmt.setString(2,"li%");ResultSetrs=pstmt.executeQuery(); booleancheck;intno=0;StringuserId=rs.getString(1);Stringname=rs.getString(2);Stringpwd=rs.getString(3);String System.out.println(no++);//顯示從0}十六、i++與++i1i++與++i是一行獨(dú)立代碼3System.out.println(++i);執(zhí)行流程為i1的動(dòng)作己完成，因?yàn)?+動(dòng)作寫在變量之前i時(shí)，++的動(dòng)作己發(fā)生4System.out.println(i++);執(zhí)行流程為i,并且使用，然后執(zhí)行++操作，所以與++操作沒(méi)有關(guān)系5intintStringuserId=rs.getString(1);Stringname=rs.getString(2);Stringpwd=rs.getString(3);String System.out.println(no++);//顯示從0開始}十七、PreparedStatement1sqlinsert/update/deletesql語(yǔ)句是帶參數(shù)工作的Stringsql="insertintoUSER_REGvalues(?,?,?,?)";PreparedStatementpstmt=conn.prepareStatement(sql);pstmt.setString(1"aTestPA");pstmt.setString(2,"預(yù)編A");pstmt.setString(3,"aaaa");pstmt.setString(4,"學(xué)生");intan=pstmt.executeUpdate();whereuser_id=?";PreparedStatementpstmt.setString(1預(yù)編A-改改");pstmt.setString(2,"bbbb");pstmt.setString(3,"講師");pstmt.setString(4,"aTestPA");intan=pstmt.executeUpdate();Stringsql="deletefromUSER_REGwhereuser_id=?";PreparedStatementpstmt.setString(1,intan=pstmt.executeUpdate();PreparedStatementStatement1StatementPreparedStatement2PreparedStatement處理有sql3PreparedStatement本身可以對(duì)數(shù)據(jù)表CRUD操作Statement相同十九、Statement1Statementsql二十、關(guān)于CallableStatement過(guò)程調(diào)1、準(zhǔn)備一個(gè)過(guò)createorre ceprocedurecreateorre ceprocedureMyprocedure(user_idinvarchar2,nameinvarchar2,passwordinvarchar2,user_typeinvarchar2)insertintouser_regvalues(user_id,name,password,user_type);--Localvariablesiinteger;--Localvariablesiinteger;--Teststatements3Stringsql="callmyprocedure(?,?