jdbc 基礎學習

package study;import java.sql.*;import java.util.Scanner;//public class StudyJdbc {////public static void main(String[] args) {//Connection conn = null;//Statement st = null;//ResultSet rs = null;//try {//Class.forName("org.gjt.mm.mysql.Driver");//conn = DriverManager.getConnection(//"jdbc:mysql://localhost:3306/fly", "root", "");//st = conn.createStatement();//rs = st.executeQuery("select * from message");//while (rs.next())//System.out.println(rs.getInt("id") + " : "//+ rs.getString("content"));//} catch (ClassNotFoundException e) {//e.printStackTrace();                     //寫到錯誤記錄檔裡//} catch (SQLException e) {//e.printStackTrace();//} finally {//try {//if (rs != null)//rs.close();//if (st != null)//st.close();//if (conn != null)//conn.close();//} catch (SQLException e) {//e.printStackTrace();//}//}//}     //在eclipse中查看資料庫中的內容//}//public class StudyJdbc {////////PreparedStatment 預先處理，過濾一些特殊字元消除sql注入,效率也更高//public static void main(String[] args) {//Connection conn = null;//PreparedStatement st = null;//try {//Class.forName("org.gjt.mm.mysql.Driver");//conn = DriverManager.getConnection(//"jdbc:mysql://localhost:3306/fly", "root", "");//st=conn.prepareStatement("insert into message values(null,?,current_timestamp)");//? 預留位置////select * from message where id=? and content=?//st.setString(1, "你好啊");//st.executeUpdate();//} catch (ClassNotFoundException e) {//e.printStackTrace();                     //寫到錯誤記錄檔裡//} catch (SQLException e) {//e.printStackTrace();//} finally {//try {//if (st != null)//st.close();//if (conn != null)//conn.close();//} catch (SQLException e) {//e.printStackTrace();//}//}//}     //在eclipse中查看資料庫中的內容//}//public class StudyJdbc {////////批處理//public static void main(String[] args) {//Connection conn = null;//PreparedStatement st = null;//try {//Class.forName("org.gjt.mm.mysql.Driver");//conn = DriverManager.getConnection(//"jdbc:mysql://localhost:3306/fly", "root", "");//st=conn.prepareStatement("insert into message values(null,?,current_timestamp)");//? 預留位置////st.setString(1, "批處理1");//st.addBatch();  ////st.setString(1, "批處理2");//st.addBatch();//st.setString(1, "批處理3");//st.addBatch();//////st.executeBatch();//插入時三條一起//} catch (ClassNotFoundException e) {//e.printStackTrace();                     //寫到錯誤記錄檔裡//} catch (SQLException e) {//e.printStackTrace();//} finally {//try {//if (st != null)//st.close();//if (conn != null)//conn.close();//} catch (SQLException e) {//e.printStackTrace();//}//}//}     //在eclipse中查看資料庫中的內容//}//public class StudyJdbc {////////交易處理//public static void main(String[] args) {//Connection conn = null;//PreparedStatement st = null;//try {//Class.forName("org.gjt.mm.mysql.Driver");//conn = DriverManager.getConnection(//"jdbc:mysql://localhost:3306/fly", "root", "");////conn.setAutoCommit(false);//預設自動認可////st=conn.prepareStatement("insert into message values(null,?,current_timestamp)");//? 預留位置////st.setString(1, "批處理1");//st.addBatch();  ////st.setString(1, "批處理2");//st.addBatch();//st.setString(1, "批處理3");//st.addBatch();////st.executeBatch();//插入時三條一起////conn.commit();//確認提交//conn.setAutoCommit(true);//恢複自動認可//} catch (ClassNotFoundException e) {//e.printStackTrace();                     //寫到錯誤記錄檔裡//} catch (SQLException e) {//e.printStackTrace();//try{//if(conn!=null)//{//conn.rollback();//出錯時復原//conn.setAutoCommit(true);//}//}//catch(SQLException e1)//{//e1.printStackTrace();//}//} finally {//try {//if (st != null)//st.close();//if (conn != null)//conn.close();//} catch (SQLException e) {//e.printStackTrace();//}//}//}     //在eclipse中查看資料庫中的內容//}//public class StudyJdbc {////////處理可滾動的結果集//public static void main(String[] args) {//Connection conn = null;//Statement st = null;//ResultSet rs=null;//try {//Class.forName("org.gjt.mm.mysql.Driver");//conn = DriverManager.getConnection(//"jdbc:mysql://localhost:3306/fly", "root", "");//////需要開發包的支援 並設置下麵的參數//st=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);//只讀，不能更新//rs=st.executeQuery("select * from message");////rs.next();//不指定上面兩個參數的話，只能用rs.next();//System.out.println(rs.getInt("id"));//rs.last();//System.out.println(rs.getInt("id"));////rs.previous()  ;////rs.absolute(8);//} catch (ClassNotFoundException e) {//e.printStackTrace();                     //寫到錯誤記錄檔裡//} catch (SQLException e) {//e.printStackTrace();//} finally {//try {//if (st != null)//st.close();//if (conn != null)//conn.close();//} catch (SQLException e) {//e.printStackTrace();//}//}//}     //在eclipse中查看資料庫中的內容//}//public class StudyJdbc {////////處理可更新的結果集//public static void main(String[] args) {//Connection conn = null;//Statement st = null;//ResultSet rs=null;//try {//Class.forName("org.gjt.mm.mysql.Driver");//conn = DriverManager.getConnection(//"jdbc:mysql://localhost:3306/fly", "root", "");//////需要開發包的支援 並設置下麵的參數//st=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);//只讀，可更新//rs=st.executeQuery("select * from message");////rs.next();//不指定上面兩個參數的話，只能用rs.next();////更新一行資料//rs.updateString("content", "可更新");//更新記憶體中資料//rs.updateRow();//更新資料庫中的內容//////插入新行//rs.moveToInsertRow();//rs.updateString("content", "AAAA");//rs.insertRow();////將游標移動到建立的行//rs.moveToInsertRow();//////刪除行//rs.absolute(3);//rs.deleteRow();////} catch (ClassNotFoundException e) {//e.printStackTrace();                     //寫到錯誤記錄檔裡//} catch (SQLException e) {//e.printStackTrace();//} finally {//try {//if (st != null)//st.close();//if (conn != null)//conn.close();//} catch (SQLException e) {//e.printStackTrace();//}//}//}     //在eclipse中查看資料庫中的內容//}