Shulou(Shulou.com)06/01 Report--

The package of sqlite adopted this time is sqlite-jdbc-3.6.0.jar

Package com.***.app.mappcore.impl.util

Import java.io.File

Import java.sql.Connection

Import java.sql.ResultSet

Import java.sql.SQLException

Import java.sql.Statement

Import java.util.ArrayList

Import java.util.List

Import com.ygsoft.ecp.app.mappcore.impl.ext.config.BaseConfig

Import com.ygsoft.ecp.service.log.EcpLogFactory

Import com.ygsoft.ecp.service.log.IEcpLog

Import com.ygsoft.ecp.service.tool.StringUtil

Public class SQLiteUtil {

/ * *

* Log

, /

Private static final IEcpLog LOG = EcpLogFactory.getLog (SQLiteUtil.class)

Public SQLiteUtil () {

}

/ * *

* Internal

* Internal lazy loading class.

* @ author mapengfei

* @ version 1.0.0 May 31, 2016

* @ see

* @ since JDK 1.5.0

, /

Private static class LazyHolder {

Private static final SQLiteUtil INSTANCE = new SQLiteUtil ()

}

/ * *

* New implementation of singleton

* @ return

, /

Public static final SQLiteUtil getInstance () {

Return LazyHolder.INSTANCE

}

Public static void main (final String [] args) {

/ / try {

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

/ / Connection conn =

/ / DriverManager.getConnection ("jdbc:sqlite:abc.db")

/ / initialize the thread pool

/ / ConnectionPool pool = initPool ()

/ get a link from the connection pool

/ / Connection conn = pool.getCurrentConnecton ()

/ / Statement stat = conn.createStatement ()

/ / stat.executeUpdate ("create table tbl1 (name varchar (20), salary)

/ / int); "); / /?

/ / stat.executeUpdate ("insert into tbl1 values ('ZhangSan',8000);")

/

/ / stat.executeUpdate ("insert into tbl1 values ('LiSi',7800);")

/ / stat.executeUpdate ("insert into tbl1 values ('WangWu',5800);")

/ / stat.executeUpdate ("insert into tbl1 values ('I', 9100);")

/ ResultSet rs = stat.executeQuery ("select * from tbl1;"); / /

/ / initialize data

SQLiteUtil util = new SQLiteUtil ()

/ / util.initParametersTable ()

For (int iTuno Bandi)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.