JDBC_ExecuteUpdate

最新推荐文章于 2022-08-01 09:28:32 发布

chizhuo1320

最新推荐文章于 2022-08-01 09:28:32 发布

阅读量173

点赞数

文章标签：数据库 java

原文链接：https://my.oschina.net/u/2363350/blog/682285

版权

1. ExecuteQuery ResultSet --> Column Index

Class UtiDb

import java.sql.DriverManager;
 import java.sql.SQLException;
 import java.sql.Statement;
  /**
  * Created by linux_ccmj on 16-5-10.
  */
 public class UtiDb {
     // MySQL url address
     private static String urlJdb = "jdbc:mysql://localhost:3306/db_book?useUnicode=true&characterEncoding=utf8";
      // MySQL user name
     private static String namUseDb = "root";
     // MySQL user password
     private static String pasUseDb = "ccmj";
      // MySQL driver name
     private static String namDriDb = "com.mysql.jdbc.Driver";
      /**
      * Get connection
     * @author Linux_ccmj
     * @date 16-5-10 下午7:12
     * @method getConFun()
     * @parameters
     * @return Connection
     * @throws ClassNotFoundException, SQLException
     */
     public Connection getConFun() throws ClassNotFoundException, SQLException {
         Class.forName(namDriDb);
         Connection con = DriverManager.getConnection(urlJdb, namUseDb, pasUseDb);
         return con;
     }
      /**
      * Close connection
     * @author Linux_ccmj
     * @date 16-5-10 下午7:16
     * @method clsConFun
     * @parameters Connection
     * @return
     * @throws SQLException
     */
     public void clsConFun(Statement sta, Connection con) throws SQLException {
         if (sta!=null){
             if (con!=null){
                 con.close();
             }
         }
     }
 }

Class ListBook

package JavaJDBC.Chap05.sec01;
 
 import JavaJDBC.util.UtiDb;
 
 import java.sql.Connection;
 import java.sql.PreparedStatement;
 import java.sql.ResultSet;
 
 /**
  * Created by linux_ccmj on 16-5-15.
  */
 public class ListBook {
     // utiDb
     private static UtiDb utiDb = new UtiDb();
     // List book fun
     /**
      * List book of t_book2
      * @throws Exception
      */
     private static void lisBooFun() throws Exception {
         // Connection, sql command string, preparedstatement
         Connection con = utiDb.getConFun();
         String strComSql = "select * from t_book2";
         PreparedStatement staPre = con.prepareStatement(strComSql);
         ResultSet lisRes = staPre.executeQuery();
         // Result set, set next, display result
         while (lisRes.next()){
             int id = lisRes.getInt(1);
             String namBoo = lisRes.getString(2);
             float priBoo = lisRes.getFloat(3);
             String namAut = lisRes.getString(4);
             int idTypBoo = lisRes.getInt(5);
             System.out.println("Book id: " + id + ", " + namBoo + ", " + priBoo
                     + ", "+namAut+", "+idTypBoo);
             System.out.println("==================================");
         }
         // Close prepared statement, connection
         utiDb.clsConFun(staPre, con);
     }
     // Test main
     public static void main(String[] args) throws Exception {
         // List book
         lisBooFun();
     }
 }

2. ExecuteQuery ResultSet --> Column Label

Class UtiDb

Class ListBook

package JavaJDBC.Chap05.sec01;
 
 import JavaJDBC.util.UtiDb;
 
 import java.sql.Connection;
 import java.sql.PreparedStatement;
 import java.sql.ResultSet;
 
 /**
  * Created by linux_ccmj on 16-5-15.
  */
 public class ListBook {
     // utiDb
     private static UtiDb utiDb = new UtiDb();
     // List book fun
     /**
      * List book of t_book2
      * @throws Exception
      */
     private static void lisBooFun() throws Exception {
         // Connection, sql command string, preparedstatement
         Connection con = utiDb.getConFun();
         String strComSql = "select * from t_book2";
         PreparedStatement staPre = con.prepareStatement(strComSql);
         ResultSet lisRes = staPre.executeQuery();
         // Result set, set next, display result
         while (lisRes.next()){
             int id = lisRes.getInt(1);
             String namBoo = lisRes.getString(2);
             float priBoo = lisRes.getFloat(3);
             String namAut = lisRes.getString(4);
             int idTypBoo = lisRes.getInt(5);
             System.out.println("Book id: " + id + ", " + namBoo + ", " + priBoo
                     + ", "+namAut+", "+idTypBoo);
             System.out.println("==================================");
         }
         // Close prepared statement, connection
         utiDb.clsConFun(staPre, con);
     }
 
     private static void lisBooFun2() throws Exception {
         // Connection, sql command string, preparedstatement
         Connection con = utiDb.getConFun();
         String strComSql = "select * from t_book2";
         PreparedStatement staPre = con.prepareStatement(strComSql);
         ResultSet lisRes = staPre.executeQuery();
         // Result set, set next, display result
         while (lisRes.next()){
             int id = lisRes.getInt("id");
             String namBoo = lisRes.getString("bookName");
             float priBoo = lisRes.getFloat("price");
             String namAut = lisRes.getString("author");
             int idTypBoo = lisRes.getInt("bookTypeId");
             System.out.println("Book id: " + id + ", " + namBoo + ", " + priBoo
                     + ", "+namAut+", "+idTypBoo);
             System.out.println("==================================");
         }
         // Close prepared statement, connection
         utiDb.clsConFun(staPre, con);
     }
 
     // Test main
     public static void main(String[] args) throws Exception {
         // List book
         // lisBooFun();
         lisBooFun2();
     }
 }

3. List<Book>

Class UtiDb

Class Book

package JavaJDBC.model;
 
 /**
  * Created by linux_ccmj on 16-5-10.
  */
 public class Book {
     private int idBoo;
     private String namBoo;
     private float priBoo;
     private String namAut;
     private int idTypBoo;
 
     public Book(int idBoo, String namBoo, float priBoo, String namAut, int idTypBoo) {
         this.idBoo = idBoo;
         this.namBoo = namBoo;
         this.priBoo = priBoo;
         this.namAut = namAut;
         this.idTypBoo = idTypBoo;
     }
 
     public Book(String namBoo, float priBoo, String namAut, int idTypBoo) {
         this.namBoo = namBoo;
         this.priBoo = priBoo;
         this.namAut = namAut;
         this.idTypBoo = idTypBoo;
     }
 
     public int getIdBoo() {
         return idBoo;
     }
 
     public void setIdBoo(int idBoo) {
         this.idBoo = idBoo;
     }
 
     public String getNamBoo() {
         return namBoo;
     }
 
     public void setNamBoo(String namBoo) {
         this.namBoo = namBoo;
     }
 
     public float getPriBoo() {
         return priBoo;
     }
 
     public void setPriBoo(float priBoo) {
         this.priBoo = priBoo;
     }
 
     public String getNamAut() {
         return namAut;
     }
 
     public void setNamAut(String namAut) {
         this.namAut = namAut;
     }
 
     public int getIdTypBoo() {
         return idTypBoo;
     }
 
     public void setIdTypBoo(int idTypBoo) {
         this.idTypBoo = idTypBoo;
     }
 
 
     @Override
     public String toString() {
         return "[ "+this.idBoo+", "+this.namBoo+", "+this.priBoo+", "+this.namAut+", "+this.idTypBoo+" ]";
     }
 }

Class ListBook

package JavaJDBC.Chap05.sec01;
 
 import JavaJDBC.model.Book;
 import JavaJDBC.util.UtiDb;
 
 import java.sql.Connection;
 import java.sql.PreparedStatement;
 import java.sql.ResultSet;
 import java.util.ArrayList;
 import java.util.List;
 
 /**
  * Created by linux_ccmj on 16-5-15.
  */
 public class ListBook {
     // utiDb
     private static UtiDb utiDb = new UtiDb();
     // List book fun
     /**
      * List book of t_book2 by column index
      * @throws Exception
      */
     private static void lisBooFun() throws Exception {
         // Connection, sql command string, preparedstatement
         Connection con = utiDb.getConFun();
         String strComSql = "select * from t_book2";
         PreparedStatement staPre = con.prepareStatement(strComSql);
         ResultSet lisRes = staPre.executeQuery();
         // Result set, set next, display result
         while (lisRes.next()){
             int id = lisRes.getInt(1);
             String namBoo = lisRes.getString(2);
             float priBoo = lisRes.getFloat(3);
             String namAut = lisRes.getString(4);
             int idTypBoo = lisRes.getInt(5);
             System.out.println("Book id: " + id + ", " + namBoo + ", " + priBoo
                     + ", "+namAut+", "+idTypBoo);
             System.out.println("==================================");
         }
         // Close prepared statement, connection
         utiDb.clsConFun(staPre, con);
     }
 
     /**
      * List book with column label
      * @throws Exception
      */
     private static void lisBooFun2() throws Exception {
         // Connection, sql command string, preparedstatement
         Connection con = utiDb.getConFun();
         String strComSql = "select * from t_book2";
         PreparedStatement staPre = con.prepareStatement(strComSql);
         ResultSet lisRes = staPre.executeQuery();
         // Result set, set next, display result
         while (lisRes.next()){
             int id = lisRes.getInt("id");
             String namBoo = lisRes.getString("bookName");
             float priBoo = lisRes.getFloat("price");
             String namAut = lisRes.getString("author");
             int idTypBoo = lisRes.getInt("bookTypeId");
             System.out.println("Book id: " + id + ", " + namBoo + ", " + priBoo
                     + ", "+namAut+", "+idTypBoo);
             System.out.println("==================================");
         }
         // Close prepared statement, connection
         utiDb.clsConFun(staPre, con);
     }
 
     /**
      * List book with list
      * @throws Exception
      */
     private static List<Book> lisBooFun3() throws Exception {
         // List, book
         List<Book> lisBoo = new ArrayList<Book>();
         // Connection, sql command string, preparedstatement
         Connection con = utiDb.getConFun();
         String strComSql = "select * from t_book2";
         PreparedStatement staPre = con.prepareStatement(strComSql);
         ResultSet lisRes = staPre.executeQuery();
         // Result set, set next, list add
         while (lisRes.next()){
             int id = lisRes.getInt("id");
             String namBoo = lisRes.getString("bookName");
             float priBoo = lisRes.getFloat("price");
             String namAut = lisRes.getString("author");
             int idTypBoo = lisRes.getInt("bookTypeId");
             Book boo = new Book(id, namBoo, priBoo, namAut, idTypBoo);
             lisBoo.add(boo);
         }
         // Close prepared statement, connection
         utiDb.clsConFun(staPre, con);
         // Return
         return lisBoo;
     }
 
     // Test main
     public static void main(String[] args) throws Exception {
         // List book
         // lisBooFun();
         // lisBooFun2();
         List<Book> lisBoo = lisBooFun3();
         for (Book boo : lisBoo){
             System.out.println(boo);
         }
     }
 }