java jdbc ÊÂÎñ¹ÜÀí
ÇмǣºÎÞÂÛhibernate»¹ÊÇjdbcµÄÊÂÎñ¿ØÖƶ¼Ó¦ÔÚservice²ã!
jdbcÊÂÎñ¹ÜÀíÒª±£Ö¤service ²ãÓëdao²ãÊÇ»ùÓÚͬһ¸öConnection;
Ò²¾ÍÊÇ˵ÔÚservice²ãÀïµÃµ½Connection £¬DAOÖз½·¨ÒÔ²ÎÊýµÄÐÎʽµÃµ½Õâ¸öʵÀý¡£¡£
δÍê´ýÐø¡£¡£¡£
Ïà¹ØÎĵµ£º
JNIÊÇJava Native InterfaceµÄËõд¡£´ÓJava 1.1¿ªÊ¼£¬Java Native Interface (JNI)±ê×¼³ÉΪjavaƽ̨µÄÒ»²¿·Ö£¬ËüÔÊÐíJava´úÂëºÍÆäËûÓïÑÔдµÄ´úÂë½øÐн»»¥¡£JNIÒ»¿ªÊ¼ÊÇΪÁ˱¾µØÒѱàÒëÓïÑÔ£¬ÓÈÆäÊÇCºÍC++¶øÉè¼ÆµÄ£¬µ«ÊÇËü²¢²»·Á°ÄãʹÓÃÆäËûÓïÑÔ£¬Ö»Òªµ÷ÓÃÔ¼¶¨ÊÜÖ§³Ö¾Í¿ÉÒÔÁË¡£
ʹÓÃjava ......
1. MySQL(http://www.mysql.com)mm.mysql-2.0.2-bin.jar ;
Class.forName( "org.gjt.mm.mysql.Driver" );
cn = DriverManager.getConnection( "jdbc:mysql://MyDbComputerNameOrIP:3306/myDatabaseName", sUsr, sPwd );
2. PostgreSQL(http://www.de.postgresql.org)pgjdbc2.jar ;
Class.forName( "org.postgresql. ......
ÔÚ³ÌÐòÖУ¬Îı¾Îļþ¾³£ÓÃÀ´´æ´¢±ê×¼µÄASCIIÂëÎı¾£¬±ÈÈçÓ¢ÎÄ¡¢¼Ó¼õ³Ë³ýµÈºÅÕâЩÔËËã·ûºÅ¡£Îı¾ÎļþÒ²¿ÉÄÜÓÃÓڴ洢һЩÆäËû·ÇASCII×Ö·û£¬Èç»ùÓÚ
GBKµÄ¼òÌåÖÐÎÄ£¬»ùÓÚBIG5µÄ·±ÌåÖÐÎĵȵȡ£ÔÚ´æ´¢ÕâЩ×Ö·ûʱÐèÒªÕýÈ·Ö¸¶¨ÎļþµÄ±àÂë¸ñʽ£»¶øÔÚ¶ÁÈ¡ÕâЩÎı¾Îļþʱ£¬ÓÐʱºò¾ÍÐèÒª×Ô¶¯Åж¨ÎļþµÄ±àÂë
¸ñʽ¡£
°´ÕÕ¸ø¶¨µÄ×Ö·û¼¯´ ......
Ê×ÏÈÒªÓÐjxlÀà¿â¡£
³ÌÐòÈçÏ£º
import java.io.*;
import jxl.*;
public class ExcelToSql {
public static void main(String args[])
{
try
{
Workbook book= Workbook.getWorkbook(new File("D:\\workspaceuse6\\foundation\\test\\com\\gres ......
×Ô¼ºÔÚ¹«Ë¾ÍøÕ¾¿ª·¢×ÜÓÃDWR¿ª·¢µÄÒ»¸ö¼òµ¥ÁÄÌì
±¾ÈËÒ²ÊÇÔÚÍøÕ¾¿ª·¢µØÍ¼Ê±Óе½ÁËÕâ¸ö¼¼Êõ£¬¸ÕѧϰDWR°ë¸öÔÂ
¾Í°ÑËæÊÖдµÄÒ»¸ö¼òµ¥ÁÄÌìÀ´¸ø´ó¼Ò¹²Ïí£¬Çдèһϡ£
ÓÉÓÚ¿¼Âǵ½Ä³Ð©¾Ö²¿ÔÒò£¬Ö»·¢±íÁËÒ»Ð©ÖØÒª¼¼Êõ·½ÃæµÄ×ÊÁÏ£¬Ã»ÓаÑÈ«²¿¶«Î÷¹²Ïí¡£Çë¸öÈËÌåÁ¡£
ÓÉÓÚDWR2.0ÓиöBug £¬ÎÒÓõÄDWR1.0£¬µ«ÊÇ£¬Ëü±ØÐëÓÃJDK1.4
......