Java Connection to SQLite database

Download the jar package:

Http://www.sqlite.com.cn/Upfiles/source/sqlitejdbc-v033-nested.tgz

 Public classTestsqlite { Public Static voidMain (string[] args) {Try {            //connect to SQLite's JDBCClass.forName ("Org.sqlite.JDBC"); //Create a connection to the database name Zieckey.db if it does not exist in the current directoryConnection conn = drivermanager.getconnection ("jdbc:sqlite:zieckey.db"); Statement Stat=conn.createstatement (); Stat.executeupdate ("CREATE table TBL1 (name varchar (), salary int);");//Create a table, two columnsStat.executeupdate ("INSERT into TBL1 values (' Zhangsan ', 8000);");//Inserting DataStat.executeupdate ("INSERT into TBL1 values (' LiSi ', 7800);"); Stat.executeupdate ("INSERT into TBL1 values (' Wangwu ', 5800);"); Stat.executeupdate ("INSERT into TBL1 values (' Zhaoliu ', 9100);"); ResultSet RS= Stat.executequery ("select * from Tbl1;");//Querying Data             while(Rs.next ()) {//Print the data you have queriedSystem.out.print ("name =" + rs.getstring ("name") + "");//Column Properties OneSystem.out.println ("salary =" + rs.getstring ("salary"));//Column Properties Two} rs.close (); Conn.close (); //to end a connection to a database}Catch(Exception e) {e.printstacktrace (); }    }}