SQL示例

来源：互联网发布：民宿知乎编辑：程序博客网时间：2024/06/06 06:40

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;}

}

0 0