SQL示例

package com.sqlite;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class PersonDao {

public static void main(String[] args) {
    try {
        Class.forName("org.sqlite.JDBC");
        Connection conn = null;
        PreparedStatement ps = null;
        ResultSet rs = null;

        conn = DriverManager
                .getConnection("jdbc:sqlite:\\D:\\150720\\week6\\romsemary.db");
        String sql = " insert into tab1509 (name,age) values(?,?)";
        ps = conn.prepareStatement(sql);
        ps.setString(1, "jing");
        ps.setInt(2, 15);
        int result = ps.executeUpdate();
        if(result>0){
            System.out.println("success");
        }else{
            System.out.println("fail");
        }
    } catch (ClassNotFoundException e) {
        e.printStackTrace();
    }
    // jdbc:sqlite:/c:/db1412.db
    catch (SQLException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }finally{

    }
}

}

package com.sqlite;

public class Person {

private int id;
private String name;
private int age;
public int getId() {
    return id;
}
public void setId(int id) {
    this.id = id;
}
public String getName() {
    return name;
}
public void setName(String name) {
    this.name = name;
}
public int getAge() {
    return age;
}
public void setAge(int age) {
    this.age = age;
}
public Person(int id, String name, int age) {
    super();
    this.id = id;
    this.name = name;
    this.age = age;
}

}