postgresql的java例項肯定可用

瓜瓜東西發表於2014-10-10
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();
		}
	}
}

相關文章