標籤:postgresql jdbc
廢話不多說,RT~
首先簡單看一下資料庫中的資料:
下面是Java測試類別的代碼:
package com.wl.test;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.ResultSetMetaData;import java.sql.Statement;public class Test {public static void main(String[] args) {try {Class.forName("org.postgresql.Driver").newInstance();String url = "jdbc:postgresql://localhost:5432/testdb";Connection con = DriverManager.getConnection(url, "postgres","111111");Statement st = con.createStatement();String sql = " select * from t_user ";ResultSet rs = st.executeQuery(sql);ResultSetMetaData rsmd = rs.getMetaData();int columnCount = rsmd.getColumnCount();while (rs.next()) {for (int i = 1; i <= columnCount; i++) {System.out.print(rs.getString(i) + "\t");}System.out.println();}rs.close();st.close();con.close();} catch (Exception e) {System.out.print("exception:" + e.getMessage());}}}
以上代碼經測試回合正常,最後再貼出postgresql 9.3的Maven依賴片段:
<!-- postgresql --><dependency><groupId>org.postgresql</groupId><artifactId>postgresql</artifactId><version>9.3-1102-jdbc4</version></dependency>
著作權聲明:本文為博主原創文章,未經博主允許不得轉載。
jdbc串連postgresql