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
Ïà¹ØÎĵµ£º
JavaÐéÄâ»ú²ÎÊý·ÖΪ»ù±¾²ÎÊýºÍÀ©Õ¹²ÎÊý£¬±¾ÎÄÖ÷ÒªÏêϸ½éÉÜ»ù±¾²ÎÊýÖи÷¸ö²ÎÊýµÄÒâÒåÒÔ¼°ÆäÓ÷¨¡£
Òª²é¿´JavaÐéÄâ»úÓÐÄÄЩ¿ÉÑ¡µÄ²ÎÊýÅäÖ㬿ÉÒÔÖ±½ÓÔËÐÐjavaÃüÁÏÔʾÈçÏÂЧ¹û£º
ϱ߷ֱð½éÉÜÿ¸ö²ÎÊýµÄÓ÷¨£º
1. -client£¬-server
ÕâÁ½¸ö²ÎÊýÓÃÓÚÉèÖÃÐéÄâ»úʹÓúÎÖÖÔËÐÐģʽ£¬clientģʽÆô¶¯±È½Ï¿ì£¬µ«ÔËÐÐʱÐÔÄܺÍÄÚ´ ......
John O'Hanley µÄÕâÆªÎÄÕÂÁоÙÁËËĸöÓꦵÄjava±àÂëϰ¹ß£¬²¢Ìá³öÁ˸ÄÕý·½°¸¡£
ÕâËĸöϰ¹ßÆÕ±é´æÔÚÓÚjava³ÌÐòÔ±ÖУ¬²¢ÇÒÒѾ±»¹ã·º½ÓÊÜ£¬´ó¼Ò¶¼Ï°ÒÔΪ³££¬Á÷¶¾ÉõÔ¶¡£
1.¶Ô¾Ö²¿±äÁ¿(local variables)£¬×Ö¶Î(fields)£¬²ÎÊý(method arguments)ÕâÈýÖÖ±äÁ¿µÄÃüÃûûÓÐÇø·Ö£¬Ôì³ÉÁË´úÂëµÄÔĶÁÀ§ÄÑ£¬Ôö¼ÓÁË´úÂëµÄά»¤³É±¾¡£
×÷Õß ......
web.xmlÎļþ¶ÔÓÚÅäÖÃÈκÎJava WebÓ¦Óö¼±ØÐèµÄ¡£
£¨1£©ÅäÖÃStrutsµÄActionServlet
<servlet><!--ÔªËØÀ´ÉùÃ÷ActionServlet-->
<servlet-name><!--ÔªËØ£ºÓÃÀ´¶¨ÒåServletµÄÃû³Æ-->
<servlet-class><!--ÔªËØ:ÓÃÀ´Ö¸¶¨ServletµÄÍêÕûÀàÃû-->
<servlet>
<servlet-name& ......
1£ºÏȶÔһЩ¸ÅÄîµÄÀí½â£º
JDBC£ºJava DataBase Connection
±¾¼¾Ä¿±ê
1¡¢JDBCµÄ·ÖÀà
2¡¢JDBCµÄÖ÷Òª²Ù×÷ÀàºÍ½Ó¿Ú£º
DriverManager¡¢Connection¡¢Statement¡¢PreparedStatement¡¢ResultSet
3¡¢ÈçºÎʹÓÃJDBCÁ¬½ÓMySQLÊý¾Ý¿â
www.mldn.cnÉÏÓÐMYSQLµÄ½Ì³Ì¡£
1¡¢Ê²Ã´ÊÇJDBC£¿
JDBCÊÇJAVAÌṩµÄÒ»¸ö·þÎñ£¬×¨ÃÅÓÃÓÚ·ÃÎÊ ......
EJB: Enterprise JavaBeans ÆóÒµJavaBean×é¼þ
IDL: Interface Definition Language ½Ó¿Ú¶¨ÒåÓïÑÔ
J2EE CA£ºJ2EE Connector Architecture J2EE Á¬½ÓÆ÷¼Ü¹¹
JAAS : The Java Authenticat ......