package jdbc;

import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import java.util.Properties;

public class Jdbc_test
{
    public static void main(String args[])
    {
        String sql_ = "SELECT * FROM user WHERE name='王梅'";

                Properties pro_ = new Properties();
        pro_.put("user", "postgres");
        pro_.put("password", "zhimakaimen(^-^)");

        try
        {
            Class.forName("org.postgresql.Driver");
        }
        catch (ClassNotFoundException e)
        {
            System.out.println( e );
        }

        try
        {
            Connection connection = DriverManager.getConnection("jdbc:postgresql://10.4.201.36:5432/AcapDB", pro_);

            Statement stmt = connection.createStatement();
            ResultSet rs = stmt.executeQuery(sql_);
            while (rs.next())
            {
                //System.out.println("rs.next()");
            }
            rs.close();
            stmt.close();
            connection.close();
        }
        catch (SQLException e)
        {
            System.out.println( e );
        }
}
}