当前位置:天才代写 > tutorial > JAVA 教程 > 简朴的JDBC应用措施for Java DB

简朴的JDBC应用措施for Java DB

2017-11-12 08:00 星期日 所属: JAVA 教程 浏览:511

副标题#e#

本日下载了jdk1.6.0,今后要逐步来进修1.6中的新特性和个中的一些经典实例。先看看关于java DB的这个最简例子:
Simple JDBC Application (源码SimpleApp.java、文档及derby.jar,derbynet.jar,derbyclient.ar文件请从jdk1.6.0中找)

这个例子是一个最小限度的JDBC 应用措施。 关于这个措施:

  • 以内嵌式模式(缺省的)或作为一个处事器情况中的客户端运行,这依赖于通报给措施的参数
  • 假如运行在内嵌式模式,则启动Derby 引擎
  • 假如运行在客户端模式,则毗连到 Derby 网络处事器
  • 建设并毗连到数据库
  • 建设一个表
  • 插入数据
  • 更新数据
  • 查询数据
  • 删除表
  • 封锁毗连
  • 假如运行在内嵌式模式,则封锁 Derby。
  • 以下是源码:

    import java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.ResultSet;
    import java.sql.SQLException;
    import java.sql.Statement;
    import java.util.Properties;
    /*
     * @author janet
     */
    public class SimpleApp
    {
        /* 缺省的模式是内嵌式的*/
        public String framework = "embedded";
        public String driver = "org.apache.derby.jdbc.EmbeddedDriver";
        public String protocol = "jdbc:derby:";
        public static void main(String[] args)
        {
            new SimpleApp().go(args);
        }
        void go(String[] args)
        {
            /* 处理惩罚参数,确定这个措施作为内嵌式利用照旧作为客户端利用*/
            parseArguments(args);
            System.out.println("SimpleApp starting in " + framework + " mode.");
            try
            {
                /*
                   装载驱动措施,假如是内嵌式模式,这将启动Derby, 因为它还没有运行.
                 */
                Class.forName(driver).newInstance();
                System.out.println("Loaded the appropriate driver.");
                Connection conn = null;
                Properties props = new Properties();
                props.put("user", "user1");
                props.put("password", "user1");
                //create=true将建设数据库derbyDB
                conn = DriverManager.getConnection(protocol +"derbyDB;create=true", props);
                System.out.println("Connected to and created database derbyDB");
                conn.setAutoCommit(false);//配置自动提交模式
                Statement s = conn.createStatement();
                /*
                   建设一个表,插手几笔记录并更新一条.
                 */
                s.execute("create table derbyDB(num int, addr varchar(40))");
                System.out.println("Created table derbyDB");
                s.execute("insert into derbyDB values (1956,'Webster St.')");
                System.out.println("Inserted 1956 Webster");
                s.execute("insert into derbyDB values (1910,'Union St.')");
                System.out.println("Inserted 1910 Union");
                s.execute(
                    "update derbyDB set num=180, addr='Grand Ave.' where num=1956");
                System.out.println("Updated 1956 Webster to 180 Grand");
                s.execute(
                    "update derbyDB set num=300, addr='Lakeshore Ave.' where num=180");
                System.out.println("Updated 180 Grand to 300 Lakeshore");
                /*
                   查询并校验功效.
                 */
                ResultSet rs = s.executeQuery(
                        "SELECT num, addr FROM derbyDB ORDER BY num");
                if (!rs.next())
                {
                    throw new Exception("Wrong number of rows");
                }
                if (rs.getInt(1) != 300)
                {
                    throw new Exception("Wrong row returned");
                }
                if (!rs.next())
                {
                    throw new Exception("Wrong number of rows");
                }
                if (rs.getInt(1) != 1910)
                {
                    throw new Exception("Wrong row returned");
                }
                if (rs.next())
                {
                    throw new Exception("Wrong number of rows");
                }
                System.out.println("Verified the rows");
                s.execute("drop table derbyDB");//删除表
                System.out.println("Dropped table derbyDB");
               
                rs.close();
                s.close();
                System.out.println("Closed result set and statement");
                conn.commit();
                conn.close();
                System.out.println("Committed transaction and closed connection");
               
                boolean gotSQLExc = false;
                if (framework.equals("embedded"))
                {
                    try
                    {
                        DriverManager.getConnection("jdbc:derby:;shutdown=true");//封锁数据库处事
                    }
                    catch (SQLException se)
                    {
                        gotSQLExc = true;
                    }
                    if (!gotSQLExc)
                    {
                        System.out.println("Database did not shut down normally");
                    }
                    else
                    {
                        System.out.println("Database shut down normally");
                    }
                }
            }
            catch (Throwable e)
            {
                System.out.println("exception thrown:");
                if (e instanceof SQLException)
                {
                    printSQLError((SQLException) e);
                }
                else
                {
                    e.printStackTrace();
                }
            }
            System.out.println("SimpleApp finished");
        }
        static void printSQLError(SQLException e)
        {
            while (e != null)
            {
                System.out.println(e.toString());
                e = e.getNextException();
            }
        }
        private void parseArguments(String[] args)
        {
           
    // System.setProperty("derby.system.home", "c:\\DBdata");//这样可以配置数据库数据的存放目次

    int length = args.length; for (int index = 0; index < length; index++) { if (args[index].equalsIgnoreCase("jccjdbcclient")) { framework = "jccjdbc"; driver = "com.ibm.db2.jcc.DB2Driver"; protocol = "jdbc:derby:net://localhost:1527/"; } if (args[index].equalsIgnoreCase("derbyclient")) { framework = "derbyclient"; driver = "org.apache.derby.jdbc.ClientDriver"; protocol = "jdbc:derby://localhost:1527/"; } } } }
    #p#副标题#e#

    #p#分页标题#e#

    下面是如何运行这个措施:
    一、奈何在内嵌式情况(集成到桌面应用)中运行这个例子
    我的事情目次是c:\java,先将derby.jar复制到c:\java\jar下。再写一个批处理惩罚文件run.bat,内容如下:
    set CLASSPATH=c:\java\jar\derby.jar;%CLASSPATH%打开windows XP的呼吁行窗口,转入事情目次。运行:
    C:\java>run.batC:\java>set CLASSPATH=c:\java\jar\derby.jar;C:\java>javac SimpleApp.java
    C:\java>java SimpleApp
    SimpleApp starting in embedded mode.
    Loaded the appropriate driver.
    Connected to and created database derbyDB
    Created table derbyDB
    Inserted 1956 Webster
    Inserted 1910 Union
    Updated 1956 Webster to 180 Grand
    Updated 180 Grand to 300 Lakeshore
    Verified the rows
    Dropped table derbyDB
    Closed result set and statement
    Committed transaction and closed connection
    Database shut down normally
    SimpleApp finished 措施运行后将在当前目次下生成

    derbyDB (目次)
    这个目次组成了 derbyDB 数据库目次. 你不能修改这个目次中的任何文件。
    derbyDB\log (目次)
    这个目次生存了数据库的事务日志.
    derbyDB\seg0 (目次)
    这个目次生存了数据库derbyDB的数据
    derbyDB\service.properties
    一个内部文件,生存了一些设置参数
    derby.LOG
    日志文件
    二、 奈何在处事器情况中运行这个例子

    (1)启动Derby Network Server

    将derbynet.jar复制到c:\java\jar中,run.bat文件改为:
    set CLASSPATH=c:\java\jar\derby.jar;c:\java\jar\derbynet.jar;%CLASSPATH%

    新开一个DOS呼吁行窗口,在这个窗口中启动 Derby Network Server,如:

    C:\java>run.bat

    C:\java>set CLASSPATH=c:\java\jar\derby.jar;c:\java\jar\derbynet.jar;

    C:\java>java org.apache.derby.drda.NetworkServerControl start
    处事器筹备在端口 1527 上接管毗连。

    (2)用 Derby 客户端模式运行这个措施:

    将 derbyclient.jar 复制到c:\java\jar中,run.bat文件改为:
    set CLASSPATH=c:\java\jar\derbyclient.jar;%CLASSPATH%

    新开一个DOS呼吁行窗口,然后以Derby 客户端模式启动SimpleApp

    C:\java>run.bat
    C:\java>set CLASSPATH=c:\java\jar\derbyclient.jar;

    C:\java>java SimpleApp derbyclient
    SimpleApp starting in derbyclient mode.
    Loaded the appropriate driver.
    Connected to and created database derbyDB
    Created table derbyDB
    Inserted 1956 Webster
    Inserted 1910 Union
    Updated 1956 Webster to 180 Grand
    Updated 180 Grand to 300 Lakeshore
    Verified the rows
    Dropped table derbyDB
    Closed result set and statement
    Committed transaction and closed connection
    SimpleApp finished

    (3)利用 IBM DB2 JDBC Universal Driver运行这个例子

    在Derby的10.0版本, IBM DB2 JDBC Universal Driver 是Derby Network Server独一的客户端驱动.驱动措施需要从 IBM的站点下载 (IBM DB2 JDBC Universal Driver, for Apache Derby Network Server). 从10.1开始, Derby网络客户端驱动措施与Derby一起分发,而且是被推荐的客户端驱动措施,但 DB2 Universal Driver还被支持而且可以象下面一样被利用:

    下载 db2jcc.jar和 db2jcc_license_c.jar,放到c:\java\jar目次下,run.bat的内容改为:
    set CLASSPATH=c:\java\jar\db2jcc.jar;c:\java\jar\db2jcc_license_c.jar;%CLASSPATH%

    C:\java>run.bat

    C:\java>set CLASSPATH=c:\java\jar\db2jcc.jar;c:\java\jar\db2jcc_license_c.jarr;

    c:\java>java SimpleApp jccjdbcclient

    #p#分页标题#e#

    A successful run produces the following output:
    SimpleApp starting in jccjdbc mode.
    Loaded the appropriate driver.
    Connected to and created database derbyDB
    Created table derbyDB
    Inserted 1956 Webster
    Inserted 1910 Union
    Updated 1956 Webster to 180 Grand
    Updated 180 Grand to 300 Lakeshore
    Verified the rows
    Dropped table derbyDB
    Closed result set and statement
    Committed transaction and closed connection
    SimpleApp finished

     

      关键字:

    [contact-form-7 id="17097" title="form2"]天才代写-代写联系方式