postgresql的java实例肯定可用

来源:互联网 发布:stage淘宝是正品吗 编辑:程序博客网 时间:2024/05/22 00:50
package com.post;import org.postgresql.*;import java.sql.*;public class TestDB {public TestDB() {}public static void main(String args[]) {System.out.print(" this is a test ");try {Class.forName("org.postgresql.Driver").newInstance();String url = "jdbc:postgresql://1.1.1.1/a";Connection con = DriverManager.getConnection(url, "b","c");Statement st = con.createStatement();String sql = "select * from testtable ";ResultSet rs = st.executeQuery(sql);while (rs.next()) {System.out.print(rs.getInt(1));System.out.println(rs.getString(2));}rs.close();st.close();con.close();} catch (Exception ee) {// System.out.print(ee.getMessage());ee.printStackTrace();}}}

0 0
原创粉丝点击