程式開發學習之路

public static String getInsertSql() {

  return  "INSERT INTO CUSTOMER (CUS_ID,CUS_NAME,CUS_AGE,CUS_ADDRESS,SALARY) " +

                "VALUES (?,?,?,?,?);"; 

 }

package com.sqlite.jdbc;



import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.SQLException;



public class InsertTableSQLiteJDBC2 {



 public static String getInsertSql() {

  return  "INSERT INTO CUSTOMER (CUS_ID,CUS_NAME,CUS_AGE,CUS_ADDRESS,SALARY) " +

                "VALUES (?,?,?,?,?);"; 

 }



 public static void main(String args[]) {

  Connection c = null;

  PreparedStatement ps = null;

  try {

   Class.forName("org.sqlite.JDBC");

   c = DriverManager.getConnection("jdbc:sqlite:data/test.db");

   c.setAutoCommit(false);

   ps = c.prepareStatement(getInsertSql());

   String cusId = "2";

   String cusName = "levin2";

   String cusAge = "23";

   String cusAddress = "新北市";

   String salary = "2000.15";

   ps.setString(1, cusId);

   ps.setString(2, cusName);

   ps.setString(3, cusAge);

   ps.setString(4, cusAddress);

   ps.setString(5, salary);

   ps.executeUpdate();

   c.commit();

   System.out.println("INSERT Table  successfully.");

  } catch (Exception e) {

   System.err.println(e.getClass().getName() + ": " + e.getMessage());

  } finally {

   try {

    if (null != ps) {

     ps.close();

    }

   } catch (SQLException e) {

    e.printStackTrace();

   }

   try {

    if (null != c) {

     c.close();

    }

   } catch (SQLException e) {

    e.printStackTrace();

   }

  }

  System.exit(0);

 }

}

• 首頁


• JAVA教學目錄


• JSP教學目錄


• Apache教學目錄


• Google App Engine教學目錄


• JBoss教學目錄


• Android教學目錄


• Grails教學目錄


• SSH教學目錄


• Window教學目錄


• Linux教學目錄


• PHP教學目錄


• C教學/C++教學目錄


• jQuery教學目錄


• HTML5教學/CSS3教學目錄


• JavaScript教學目錄


• MySQL教學目錄


• Oracle教學目錄


• SQL Server教學/PostgreSQL教學/其它資料庫教學目錄


• Eclipse教學及開發相關工具教學目錄


• 程式開發基本資訊目錄


• 其它技術教學目錄