DAO Java

最新推荐文章于 2024-11-03 11:01:20 发布

talenthua

最新推荐文章于 2024-11-03 11:01:20 发布

阅读量920

点赞数 26

文章标签： java 数据库开发语言

本文链接：https://blog.csdn.net/talenthua/article/details/136600411

版权

DAO: Data Access Object

1.PgAdmin4-->new table

tablename: bookinfo

2.DAO

/Daotest/src/com/daotest/SampleDAO1.java

package com.daotest;

import java.sql.*;
import java.util.ArrayList;

public class SampleDAO1 {
   private static final String RDB_DRIVER = "org.postgresql.Driver";
   private static final String URL = "jdbc:postgresql://localhost:5432/postgres";
   private static final String USER = "postgres";
   private static final String PASSWORD = "******";

   private static Connection getConnection() {
       try {
           Class.forName(RDB_DRIVER);
           Connection con = DriverManager.getConnection(URL, USER, PASSWORD);
           return con;
       } catch (Exception e) {
           throw new IllegalStateException(e);
       }
   }

public ArrayList<String> selectIsbnAll() {

Connection con = null;
Statement smt = null;

ArrayList<String> list = new ArrayList<String>();

String sql = "SELECT isbn FROM bookinfo ORDER BY isbn";

try {

con = SampleDAO1.getConnection();
smt = con.createStatement();

ResultSet rs = smt.executeQuery(sql);

           while (rs.next()) {
               list.add(rs.getString("isbn"));
           }

       } catch (SQLException e) {
           System.out.println("Error！\n" + e);
       } finally {

           if (smt != null) {
               try {
                   smt.close();
               } catch (SQLException ignore) {
               }
           }
           if (con != null) {
               try {
                   con.close();
               } catch (SQLException ignore) {
               }
           }
       }
       return list;
   }

public ArrayList<String> selectTitleAll() {

Connection con = null;
Statement smt = null;

ArrayList<String> list = new ArrayList<String>();

String sql = "SELECT title FROM bookinfo ORDER BY isbn";

       try {
           con = SampleDAO1.getConnection();
           smt = con.createStatement();

ResultSet rs = smt.executeQuery(sql);

           while (rs.next()) {
               list.add(rs.getString("title"));
           }

       } catch (SQLException e) {
           System.out.println("Error！\n" + e);
       } finally {
           if (smt != null) {
               try {
                   smt.close();
               } catch (SQLException ignore) {
               }
           }
           if (con != null) {
               try {
                   con.close();
               } catch (SQLException ignore) {
               }
           }
       }
       return list;
   }

   public ArrayList<Integer> selectPriceAll() {
       Connection con = null;
       Statement smt = null;

ArrayList<Integer> list = new ArrayList<Integer>();

String sql = "SELECT price FROM bookinfo ORDER BY isbn";

       try {
           con = SampleDAO1.getConnection();
           smt = con.createStatement();

ResultSet rs = smt.executeQuery(sql);

           while (rs.next()) {
               list.add(rs.getInt("price"));
           }

public int insertBook(String isbn, String title, int price) {

Connection con = null;
Statement smt = null;

int rowsCount = 0;

String sql = "INSERT INTO bookinfo(isbn, title, price) " + "VALUES('" + isbn + "','" + title + "'," + price
+ ")";

       try {
           con = SampleDAO1.getConnection();
           smt = con.createStatement();

rowsCount = smt.executeUpdate(sql);

}

       catch (SQLException e) {
           System.out.println("Error happened\n" + e);
       } finally {
           if (smt != null) {
               try {
                   smt.close();
               } catch (SQLException ignore) {

               }
           }
           if (con != null) {
               try {
                   con.close();
               } catch (SQLException ignore) {

}

}
return rowsCount;

}

postgresql-42.7.2.jar