untitled1.java

连接postsql数据库的java

package test1;
import java.sql.*;
public class Untitled1 {
  public Untitled1() {
  }

  public static void main(String[] args) {
    Untitled1 test1 = new Untitled1();

    Connection conn = null;
    java.sql.Statement stmt	= null;

    //java.sql.CallableStatement stmt = null;
    ResultSet rs = null;

    //String driver = "org.postgresql.Driver";
    //String url = "jdbc:postgresql://192.168.0.221:5432/mydb";
    String driver = "org.gjt.mm.mysql.Driver";
    String url = "jdbc:mysql://localhost/test";
    String user = "root";
    String passwd = "";

    String select = "select * from userinfo_bean ";
    String Id;
    String Name;
    String address;
    String strSQL;
    try {
      Class.forName(driver);
      //连接数据库
      conn = DriverManager.getConnection(url, user, passwd);
      if (conn != null) {
        System.out.println("dsdgg");
      }

      //准备SQL语句 "{call pgsql_test(?,?)}";
      //strSQL = "{call pgsql_test(?,?)}";
      //准备可调用语句对象
      //stmt = conn.prepareCall(strSQL);
      //设置输入参数
      stmt = conn.createStatement();
      //stmt.setString(1,"cannac");
      //登记输出参数
      //stmt.registerOutParameter(2, java.sql.Types.VARCHAR);

      rs = stmt.executeQuery(select);
//获取来自结果集中的数据

      while (rs.next()) {
        //Id = rs.getString(1);
        //获取输出参数的值
        Name = rs.getString(2);
        //address =rs.getString("address");

        System.out.println(Name);
        //System.out.println(Name + " ");
        // System.out.println(address+" ");

      }
    }
    catch (Exception e) {
      e.printStackTrace();
    }
    finally {
      try {
        // Always close properly
        if (rs != null) {
          rs.close();
        }
        if (stmt != null) {
          stmt.close();
        }
        if (conn != null) {
          conn.close();
        }
      }
      catch (Exception e) {
        e.printStackTrace();
      }
    }

  }

}