javaÖÐʹÓÃsqliteÊý¾Ý¿â
sqliteÊý¾Ý¿âµÚÈý·½javaÀ©Õ¹°üÏÂÔØµØÖ·£ºhttp://www.zentus.com/sqlitejdbc/
ÓÐ2¸ö°ü£¬Ò»¸öÊÇnested£¨Ç¶ÈëʽµÄ£©£¬Ò»¸öÊÇnative(±¾µØµÄ)¡£
Çø±ðÔÚÓÚ:nested ²»ÐèÒª¶îÍâµÄdllÎļþ£¬µ«ÊÇËÙ¶ÈÂý¡£nativeÐèÒªÒ»¸ö¶îÍâµÄdllÎļþ£¬ËٶȺܿ졣
1.ʹÓÃnested°ü£ºsqlitejdbc-v037-nested.jar
java´úÂ룺
java ´úÂë
package test;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class Test {
public static void main(String[] args) throws Exception {
System.setProperty("java.library.path", "C:/TDDOWNLOAD/SQL");
Class.forName("org.sqlite.JDBC");
Connection conn = DriverManager.getConnection("jdbc:sqlite:e:/testdb.db");
//½¨Á¢ÊÂÎñ»úÖÆ,½ûÖ¹×Ô¶¯Ìá½»£¬ÉèÖûعöµã
conn.setAutoCommit(false);
Statement stat = conn.createStatement();
stat.executeUpdate("create table people1 (name, occupation);");
stat.executeUpdate("insert into people1 values ('Gandhi', 'politics');");
stat.executeUpdate("insert into people1 values ('Turing', 'computers');");
stat.executeUpdate("insert into people1 values ('Wittgenstein', 'smartypants');");
conn.commit(); &n
Ïà¹ØÎĵµ£º
¾¹ýÁËÒ»ÖܵÄŬÁ¦£¬³É¹¦Ç©ÏÂÁËÉϺ£±¦ÐÅÈí¼þÎ÷°²·Ö¹«Ë¾¡£
ÔÚÕâÀ¼òµ¥·ÖÏíÒ»ÏÂÕâ´ÎµÄ¾Àú¡£
Ê×Ïȼòµ¥³ÂÊöϸöÈ˵ÄһЩ»ù±¾ÐÅÏ¢£¬Õý¹æÍ³Õб¾¿Æ·Ç¼ÆËã»úרҵ£¬2008-2009Äê8Ô½ÓÊܶ«·½±ê×¼Èí¼þ¹¤³ÌʦÅàѵ£¬Íê³ÉÁËһЩ±È½ÏÍêÕûµÄÏîÄ¿£¬ÕÆÎÕÁË»ù±¾µÄJ2EE¿ª·¢µÄºËÐļ¼Êõ¡£Åàѵ½áÊøÁË£¬²Î¼ÓÁËһЩ֪ÃûÆóÒµµÄУ԰ ......
JavaÐéÄâ»ú²ÎÊý·ÖΪ»ù±¾²ÎÊýºÍÀ©Õ¹²ÎÊý£¬±¾ÎÄÖ÷ÒªÏêϸ½éÉÜ»ù±¾²ÎÊýÖи÷¸ö²ÎÊýµÄÒâÒåÒÔ¼°ÆäÓ÷¨¡£
Òª²é¿´JavaÐéÄâ»úÓÐÄÄЩ¿ÉÑ¡µÄ²ÎÊýÅäÖ㬿ÉÒÔÖ±½ÓÔËÐÐjavaÃüÁÏÔʾÈçÏÂЧ¹û£º
ϱ߷ֱð½éÉÜÿ¸ö²ÎÊýµÄÓ÷¨£º
1. -client£¬-server
ÕâÁ½¸ö²ÎÊýÓÃÓÚÉèÖÃÐéÄâ»úʹÓúÎÖÖÔËÐÐģʽ£¬clientģʽÆô¶¯±È½Ï¿ì£¬µ«ÔËÐÐʱÐÔÄܺÍÄÚ´ ......
·þÎñÆ÷¶Ë£º
import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStreamReader;
import java.io.PrintWriter;
import java.net.ServerSocket;
import java.net.Socket;
public class ThreadSocketServer extends Thread {
private Socket client;
&n ......
java¶àÏ̱߳à³Ì×ܽ᣺
http://lavasoft.blog.51cto.com/62575/27069
Java¹Ø¼ü×Öfinal¡¢staticʹÓÃ×ܽá
:
http://xo-tobacoo.javaeye.com/blog/374282
¡¡¡¡1.public
¡¡¡¡¡¡¡¡Ê¹ÓöÔÏó£ºÀà¡¢½Ó¿Ú¡¢³ÉÔ±
¡¡¡¡¡¡¡¡½éÉÜ£ºÎÞÂÛËüËù´¦Ôڵİü¶¨ÒåÔÚÄÄ£¬¸ÃÀࣨ½Ó¿Ú¡¢³ÉÔ±£©¶¼ÊǿɷÃÎʵÄ
¡¡¡¡2.private
¡¡¡¡¡¡¡¡Ê¹ÓöÔÏó ......
1ÏÈ¿´Ò»Ï³ÌÐò£º
package com.redking.jdbc.demo;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class JDBCDemo07 {
......