Java sqlite3使用

首先下载sqlite3，内容如下：


如果找不到，也可以在我的资源中查找，我会上传到csdn上

使用了c3p0和jdbc两种方式

package test.sqlite;

import com.mchange.v2.c3p0.AbstractComboPooledDataSource;
import com.mchange.v2.c3p0.ComboPooledDataSource;

import javax.sql.DataSource;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
class Sqlit3C3P0{
    private static DataSource dataSource = null;

    public static synchronized DataSource getDataSource(String configName) {
        if (dataSource == null){
            dataSource = new ComboPooledDataSource(configName);
        }

        //ComboPooledDataSource sqlit3 = new ComboPooledDataSource("sqlit3");
        return dataSource;
    }
}
class SqlitJDBC{
    private static String dbName;

    public void setDbName(String dbName) {
        this.dbName = dbName;
    }

    private static DataSource dataSource = null;
    public static Connection getConnection(String dbName) {
        Connection connection = null;
        try {
            Class.forName("org.sqlite.JDBC");
            connection = DriverManager.getConnection("jdbc:sqlite:"+dbName);
        } catch (ClassNotFoundException | SQLException e) {
            e.printStackTrace();
        }
        return connection;
    }
    void createTable(String sql){
        Connection connection = getConnection(dbName);
        /*String sql = "create table user(" +
                "userId int(8) not null," +
                "username varchar(20), " +
                "password varchar(20)" +
                ")";*/
        Statement statement = null;
        boolean execute = false;
        try {
            statement = connection.createStatement();
            execute = statement.execute(sql);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        System.out.println(execute);
    }
}
public class MySqite3 {



    public static void main(String[] args) {

    }
}

c3p0-config.xml

<c3p0-config>
    <default-config>

    </default-config>

    <named-config name="sqlit3">
        <property name="jdbcUrl">jdbc:sqlite:test</property>
        <!--  :memory:   内存模式-->
        <!--<property name="jdbcUrl">jdbc:sqlite::memory:</property>-->
        <property name="driverClass">org.sqlite.JDBC</property>

        <property name="checkoutTimeout">30000</property>
        <property name="idleConnectionTestPeriod">30</property>
        <property name="initialPoolSize">10</property>
        <property name="maxIdleTime">30</property>
        <property name="maxPoolSize">10</property>
        <property name="maxStatements">200</property>
    </named-config>



</c3p0-config>