Eclipse java postgresql
如果没有安装postgresql，可参照此文安装，配置，并启动：http://blog.csdn.net/qiaoning13256/article/details/7225709Postgresql jdbc下载地址：http://jdbc.postgresql.org/download.html
Importing the driver:
[*]Right click on your prject
[*]Choose property
[*]Choose Java build path
[*]Choose add external JARS.. and select the location to the JDBC driver
Java代码：
import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class Main {public static void main(String args[]){try {Class.forName("org.postgresql.Driver");} catch (ClassNotFoundException e) {e.printStackTrace();}String url = "jdbc:postgresql://127.0.0.1/mydb";Connection conn = null;try {conn = DriverManager.getConnection(url, "qn", "");} catch (SQLException e) {e.printStackTrace();}Statement stat = null;try {stat = conn.createStatement();} catch (SQLException e) {e.printStackTrace();}String sqlTemplate = "select * from userinfo where username = '%s' and password = '%s'";String sqlsel = String.format(sqlTemplate, "qiaoning", "hello");ResultSet resultSet = null;try {resultSet = stat.executeQuery(sqlsel);} catch (SQLException e) {e.printStackTrace();}try {while(resultSet.next()){System.out.println(resultSet.getString(1));System.out.println(resultSet.getString(2));}} catch (SQLException e) {e.printStackTrace();}}}
页:
[1]