login.java

weblogic应用全实例

//声明本类包含在包examples.jdbc.informix4中
package examples.jdbc.informix4;
//声明本类要引入的其他包和类
import java.sql.*;
import java.util.Properties;

/**
 * 这个简单的例子演示建立一个Informix实例的连接。
 */
public class login {

  public static void main(String argv[])
  {
  //声明连接变量
    java.sql.Connection conn1 = null;
    java.sql.Connection conn2 = null;
    try {
    
      // 声明并设置属性对象
    
      Properties props = new Properties();
      props.put("user",     "informix");
      props.put("password", "secret");
      props.put("server",   "myDBHost"); // Informix服务器运行的主机名
      props.put("port",     "1493");       // Informix服务器的监听端口
      props.put("db",       "myDB");  // Informix服务器数据库名
    
      //加载驱动程序
      Driver myDriver= (Driver)
      Class.forName("weblogic.jdbc.informix4.Driver").newInstance();
      //建立连接
      conn1 = myDriver.connect("jdbc:weblogic:informix4", props);
      System.out.println("Logged in successfully with style #1.");
	//设置属性对象2    
      Properties props2 = new Properties();
      props2.put("user",     "informix");
      props2.put("password", "secret");
	//连接
      conn2 = myDriver.connect("jdbc:weblogic:informix4:myDB@myDBHost:1493", props2 );
    
      System.out.println("Logged in successfully with style #2.");
    } catch (Exception e) {
    //异常处理
        System.out.println("Exception was thrown: " + e.getMessage());
    } finally {
    	//关闭连接
        try {
          if (conn1 != null)
            conn1.close();
          if (conn2 != null)
            conn2.close();
        } catch (SQLException sqle) {
            System.out.println("SQLException was thrown: " + sqle.getMessage());
        }
    }
  }
}