exsql.java

weblogic应用全实例

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

/**
 * 这个实例演示JDBC使用扩展SQL，嵌入到标准SQL。
 */

public class exsql
{
  public static void main(String argv[])
  {
  //声明连接，SQL语句和结果集变量	
    java.sql.Connection conn = null;
    java.sql.Statement stmt  = null;
    java.sql.ResultSet rs    = null;
    Driver myDriver = null;
    //声明属性变量
    Properties props = new Properties();
    //设置属性：用户名、密码、服务器
    props.put("user", "sa");
    props.put("password", "secret");
    props.put("server", "myhost:1433");

    try
      {
      	//加载数据库驱动程序
	myDriver = (Driver)Class.forName("weblogic.jdbc.mssqlserver4.Driver").newInstance();
	//创建连接
	conn = myDriver.connect("jdbc:weblogic:mssqlserver4", props );
	//创建SQL语句对象
        stmt = conn.createStatement();
	
        // 这个SQL实例包括一些扩展的SQL
        // 扩展SQL语句放在{}中。这个例子使用函数dayname, 函数now(),和一个日期，时间
	//声明扩展SQL命令	
        String exsql = "select {fn dayname {fn now()}},   -- Today    \n" +
	  "           {d '1997-05-24'},  -- a date                    \n" +
	  "           {t '10:30:29' },  -- a time                     \n" +
	  "           {ts '1997-05-24 10:30:29.123'}, -- a timestamp  \n" +
	  "          '{string data with { or } will not be altered'   \n" +
	  "--  Also note that you can safely include } and { in comments";
	//打印这个命令
        System.out.println(" The Extended SQL:\n" + exsql + "\n\n becomes:\n");
        System.out.println( conn.nativeSQL( exsql ));
	//执行扩展SQL
        rs = stmt.executeQuery( exsql );
	//打印结果
        while (rs.next())
          System.out.println("Got:\n " + rs.getString(1) +
                               "\n "   + rs.getString(2) +
                               "\n "   + rs.getString(3) +
                               "\n "   + rs.getString(4) +
                               "\n "   + rs.getString(5) );
      } catch (Exception e) {
      //异常处理
	  e.printStackTrace();
      } finally {
      	//关闭
	  try {
            if (stmt != null)
              stmt.close();
            if (rs != null)
              rs.close();
            if (conn != null)
              conn.close();
          } catch (SQLException sqle) {
          //异常处理
              System.out.println("SQLException was thrown: " + sqle.getMessage());
          }
      }
  }
}