simplesql.java

来自「weblogic应用全实例」· Java 代码 · 共 57 行

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

/**
 * 这个实例演示怎样使用JDBC执行DDL和DML。
 */
public class simplesql
{
  
  public static void main(String argv[])
  {
  //声明连接，SQL语句变量
    java.sql.Connection conn = null;
    java.sql.Statement stmt  = null;
    //设置属性变量：用户、密码和服务器
    Properties props = new Properties();
    props.put("user", "sa");
    props.put("password", "secret");
    props.put("server", "myHost:1433");

    try {
    //加载数据库驱动程序
      Driver myDriver = (Driver)Class.forName("weblogic.jdbc.mssqlserver4.Driver").newInstance();
      //创建连接
      conn = myDriver.connect("jdbc:weblogic:mssqlserver4", props);
      //创建SQL语句对象
      stmt = conn.createStatement();
      //执行SQL语句
      stmt.execute("create table #empdemo (empid integer, name varchar(30), dept integer)");
      System.out.println("Table empdemo created.");
      //插入一条记录
      int numrows = stmt.executeUpdate("insert into #empdemo values (0, 'John Smith', 12)");
      System.out.println("Number of rows inserted = " + numrows);
      //删除一个记录
      numrows = stmt.executeUpdate("delete from #empdemo where empid = 0");
      System.out.println("Number of rows deleted = " + numrows);
    } catch (Exception e) {
    //异常处理
        System.out.println("Exception was thrown: " + e.getMessage());
    } finally {
    //关闭
        try {
          if (stmt != null)
            stmt.close();
          if (conn != null)
            conn.close();
        } catch (SQLException sqle) {
        //异常处理
            System.out.println("SQLException was thrown: " + sqle.getMessage());
        }
    }
  }
}