傳智播客JDBC視頻教程筆記_圖文

1、第二章1. 注冊(cè)驅(qū)動(dòng)方法(1、DriverManager.registerDriver( new com.mysql.jdbc.Driver(;(2、(可以用:注冊(cè)多個(gè)”;(3、Class.forName(” com.mysql.jdbc.Driver”; /推薦方式2. 建立連接Connection conn = DriverManager.getConnection(“jdbc:mysql:/localhost:3306/jdbc”,”root”,”;url格式：JDBC: 子協(xié)議：子名稱(chēng)/主機(jī)名：端口/數(shù)據(jù)庫(kù)名3. 創(chuàng)建語(yǔ)句Statement st = conn.createStatem

2、ent(;4. 執(zhí)行語(yǔ)句ResultSet rs = st.executeQuery(“select * from user”; /查詢(xún)Int i =St.executeUpdate(sql; /更新、插入、刪除,返回受影響行數(shù)5. 處理結(jié)果While(Rs.next(System.out.println(rs.getObject(1 + “t” + rs.getObject(2;6. 釋放資源Rs.close(;St.close(;Conn.close(;“ or 1 or ” sql注入，這樣用這個(gè)來(lái)登陸也可以成功。String sql = “select id from user whe

3、re name =?”P(pán)reparedStatement ps = conn.prepareStatement(sql;Ps.setString( 1 , name ; /這樣不會(huì)產(chǎn)生sql注入問(wèn)題。PreparedStatement效率比Statement高11、 clob大文本類(lèi)型MySQL為T(mén)EXT類(lèi)型讀取：Clob clob = rs.getClob(1;Reader reader = clob.getCharacterStream(;File fie = new File(“text.java”;Writer writer = new BufferedWriter(new FileW

4、riter(file;Char buff = new char1024;For(int i=0;(i=reader.read(buff>0;writer.write(buff,0,i;writer.close(;reader.close(;11、大二進(jìn)制類(lèi)型blobSQL Server 稱(chēng)Image MySQL稱(chēng)BLOBReader處理字符流 InputStream處理字節(jié)流讀?。?4、創(chuàng)建存儲(chǔ)過(guò)程使用存儲(chǔ)過(guò)程返回插入的主鍵自己編寫(xiě)代碼返回主鍵25、批處理26、可滾動(dòng)的結(jié)果集27、 可更新的結(jié)果集31、反射技術(shù)。通過(guò)傳給的Class，構(gòu)造出對(duì)象通過(guò)方法名調(diào)用方法 Static

5、void invoke1(Objet obj , Stirng methodNameMethod ms = obj.getClass(.getDeclaredMethods(;/ms = obj.getClass(.getMethods(;Fro(Method m: ms/System.out.println(m.getName(;If(methodName.equals(m.getName(m.invoke(obj,null;獲取屬性Static void field(Class clazz throws ExceptionField fs = class.getDeclaredFields(;fs = clazz.getFields(; /獲得公共域for(