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¿ª·¢µÄºËÐļ¼Êõ¡£Åàѵ½áÊøÁË£¬²Î¼ÓÁËһЩ֪ÃûÆóÒµµÄУ԰ ......
×¼±¸¹¤×÷
Ê×ÏÈ£¬²Ù×÷ϵͳÖа²×°ºÃSQL Server 2000/2005£¬Èç¹ûϵͳÖж¼×°ÓÐ2000ºÍ2005°æ£¬¼ÇµÃÍ£ÓÃÒ»¸ö£¬Ö»¿ªÒ»¸öÐÐÁË¡£
È»ºó£¬µ½Î¢ÈíÍøÕ¾ÏÂÔØMicrosoft SQL Server 2005 JDBC Driver 1.1
£¬Ò²¿ÉÒÔʹÓÃÕâ¸öµØÖ·Ö±½ÓÏÂÔØ
¡£
½âѹsqljdbc_1.1.1501.101_chs.exe£¬°Ñsqljdbc_1.1¸´ÖƵ½%ProgramFiles%£¨Èç¹ûϵͳÔÚCÅÌÔòΪC:\ ......
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 ......