一、建立 INSERT TABLE SQL
public static String getInsertSql(String cusId,String cusName,String cusAge,String cusAddress,String salary) {
return "INSERT INTO CUSTOMER (CUS_ID,CUS_NAME,CUS_AGE,CUS_ADDRESS,SALARY) " +
"VALUES ("+cusId+",'"+cusName+"',"+cusAge +",'"+ cusAddress+"',"+ salary+");";
}
二、程式
package com.sqlite.jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class InsertTableSQLiteJDBC {
public static String getInsertSql(String cusId,String cusName,String cusAge,String cusAddress,String salary) {
return "INSERT INTO CUSTOMER (CUS_ID,CUS_NAME,CUS_AGE,CUS_ADDRESS,SALARY) " +
"VALUES ("+cusId+",'"+cusName+"',"+cusAge +",'"+ cusAddress+"',"+ salary+");";
}
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");
c.setAutoCommit(false);
stmt = c.createStatement();
stmt.executeUpdate(getInsertSql("1","levin","23","新北市","2000.15"));
c.commit();
System.out.println("INSERT Table successfully.");
} 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.exit(0);
}
}
三、建立測試專案
參考：Java Using SQLite
四、執行程式
圖1
五、查看資料
參考：SQLite Manager For Firefox
圖2
五、相關文章
Java Using SQLite
SQLite CREATE TABLE Using Java
SQLite INSERT TABLE Using Java
SQLite SELECT TABLE Using Java
SQLite UPDATE TABLE Using Java
SQLite DELETE TABLE Using Java
其它文章
沒有留言:
張貼留言