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