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();
}
}
}
postgresql的java实例肯定可用
最新推荐文章于 2024-06-18 14:32:39 发布