• Java向Access插入数据


    Connection conn = null;
      Statement stmt1 = null;

      System.out.println("Start write access...");
      try {
       String strurl = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=abc.mdb";
       Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //驱动程序
       conn = DriverManager.getConnection(strurl); //建立连接对象
       
       stmt1 = conn.createStatement();
       
       System.out.println("append records:");
       String sql = "insert into Table_A (Id,Description) values (504,?)";
      
       PreparedStatement ps = conn.prepareStatement(sql);
       ps.setString(1,"vvv");
       ps.executeUpdate();
       
       System.out.println("success.");
      }
      catch(ClassNotFoundException cnfe)
      {
       System.out.println("error:" + cnfe.getMessage());
      }
      catch(SQLException sqlExp)
      {
       System.out.println("error:" + sqlExp.getMessage());
      }
      catch(Exception e)
      {
       System.out.println("error:" + e.getMessage());
      }
      finally
      {
       if(stmt1 != null)
       {
        try
        {
         stmt1.close();
        }
        catch(Exception e)
        {
         System.out.println("error:" + e.getMessage());
        }
       }

       if(conn != null)
       {
        try
        {
        conn.close();
        }
        catch(Exception e)
        {
         System.out.println("error:" + e.getMessage());
        }
       }
      }

  • 相关阅读:
    Java生产者与消费者(下)
    Java生产者与消费者(上)
    Java中的继承和接口
    syslog(),closelog()与openlog()--日志操作函数
    Nagle算法
    TCP_NODELAY详解
    Linux "零拷贝" sendfile函数中文说明及实际操作分析
    pdflush的工作原理
    proc/sys/net/ipv4/下各项的意义
    求最低价格
  • 原文地址:https://www.cnblogs.com/huqingyu/p/916002.html
Copyright © 2020-2023  润新知