程式開發學習之路

 CREATE TABLE CUSTOMER

( CUS_ID INT PRIMARY KEY     NOT NULL,

  CUS_NAME           TEXT    NOT NULL,

  CUS_AGE            INT     NOT NULL,

  CUS_ADDRESS        CHAR(50),

  SALARY         REAL)

package com.sqlite.jdbc;



import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

import java.sql.Statement;



public class CreateTableSQLiteJDBC {



 public static String getTable() {

  return  "CREATE TABLE CUSTOMER " + 

    "(CUS_ID INT PRIMARY KEY     NOT NULL," + 

    " CUS_NAME           TEXT    NOT NULL, " + 

    " CUS_AGE            INT     NOT NULL, " + 

    " CUS_ADDRESS        CHAR(50), " + 

    " SALARY         REAL)";

 }



 public static void main(String args[]) {

  Connection c = null;

  Statement stmt = null;

  try {

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

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

   stmt = c.createStatement();

   stmt.executeUpdate(getTable());

  } catch (Exception e) {

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

  }finally{

   try {

    if(null != stmt){

     stmt.close();

    }

   } catch (SQLException e) {

    e.printStackTrace();

   }

   try {

    if(null != c){

     c.close();

    }

   } catch (SQLException e) {

    e.printStackTrace();

   }

  }

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

  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教學及開發相關工具教學目錄


• 程式開發基本資訊目錄


• 其它技術教學目錄