postgresql的java实例肯定可用

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();
		}
	}
}

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!