JAVAÁ¬½Ó³Ø
package com.xinnuo.jdbc;
import java.io.*;
import java.sql.*;
import java.util.*;
import java.util.Date;
/*
* ¸ÃÀàÖ»ÄÜ´´½¨Ò»¸öʵÀý£¬ÆäËü¶ÔÏóÄܹ»µ÷ÓÃÆä¾²Ì¬·½·¨£¨Ò²³ÆÎªÀà·½·¨£©»ñµÃ¸ÃΨһʵÀýµÄÒýÓá£
* DBConnectionManagerÀàµÄ½¨¹¹º¯ÊýÊÇ˽Óеģ¬ÕâÊÇΪÁ˱ÜÃâÆäËü¶ÔÏó´´½¨¸ÃÀàµÄʵÀý.
* DBConnectionManagerÀàµÄ¿Í»§³ÌÐò¿ÉÒÔµ÷ÓÃgetInstance()·½·¨»ñµÃ¶Ô¸ÃÀàΨһʵÀýµÄÒýÓá£
* ÀàµÄΨһʵÀýÔÚgetInstance()·½·¨µÚÒ»´Î±»µ÷ÓÃÆÚ¼ä´´½¨£¬´ËºóÆäÒýÓþÍÒ»Ö±±£´æÔÚ¾²Ì¬±äÁ¿
* instanceÖС£Ã¿´Îµ÷ÓÃgetInstance()¶¼Ôö¼ÓÒ»¸öDBConnectionManagerµÄ¿Í»§³ÌÐò¼ÆÊý¡£
* ¼´£¬¸Ã¼ÆÊý´ú±íÒýÓÃDBConnectionManagerΨһʵÀýµÄ¿Í»§³ÌÐò×ÜÊý£¬Ëü½«±»ÓÃÓÚ¿ØÖÆÁ¬½Ó³ØµÄ
* ¹Ø±Õ²Ù×÷¡£ ¸ÃÀàʵÀýµÄ³õʼ»¯¹¤×÷˽Óз½·¨init()Íê³É¡£ÆäÖÐ getResourceAsStream()·½·¨
* ÓÃÓÚ¶¨Î»²¢´ò¿ªÍⲿÎļþ¡£ÍⲿÎļþµÄ¶¨Î»·½·¨ÒÀÀµÓÚÀà×°ÔØÆ÷µÄʵÏÖ¡£±ê×¼µÄ±¾µØÀà×°ÔØÆ÷²éÕÒ²Ù
* ×÷×ÜÊÇ¿ªÊ¼ÓÚÀàÎļþËùÔÚ·¾¶£¬Ò²Äܹ»ËÑË÷CLASSPATHÖÐÉùÃ÷µÄ·¾¶¡£db.propertiesÊÇÒ»¸öÊôÐÔ
* Îļþ£¬Ëü°üº¬¶¨ÒåÁ¬½Ó³ØµÄ¼ü-Öµ¶Ô¡£¿É¹©¶¨ÒåµÄ¹«ÓÃÊôÐÔÈçÏ£º
* drivers ÒÔ¿Õ¸ñ·Ö¸ôµÄJDBCÇý¶¯³ÌÐòÀàÁбí\\
* logfile ÈÕÖ¾ÎļþµÄ¾ø¶Ô·¾¶
* ÆäËüµÄÊôÐÔºÍÌØ¶¨Á¬½Ó³ØÏà¹Ø£¬ÆäÊôÐÔÃû×ÖǰӦ¼ÓÉÏÁ¬½Ó³ØÃû×Ö£º
* < poolname>.url Êý¾Ý¿âµÄ JDBC URL
* < poolname>.maxconn ÔÊÐí½¨Á¢µÄ×î´óÁ¬½ÓÊý£¬0±íʾûÓÐÏÞÖÆ
* < poolname>.user ÓÃÓÚ¸ÃÁ¬½Ó³ØµÄÊý¾Ý¿âÕʺÅ
* < poolname>.password ÏàÓ¦µÄÃÜÂë\\
* ÆäÖÐurlÊôÐÔÊDZØÐèµÄ£¬¶øÆäËüÊôÐÔÔòÊÇ¿ÉÑ¡µÄ¡£Êý¾Ý¿âÕʺźÍÃÜÂë±ØÐëºÏ·¨¡£ÓÃÓÚWindowsƽ̨µÄ
* db.propertiesÎļþʾÀýÈçÏ£º
* drivers=com.microsoft.jdbc.sqlserver.SQLServerDriver
* logfile=D:\\log.txt
* access.maxconn=20
* access.url=jdbc:microsoft:sqlserver://localhost:1433;databasename=web
* access.user=sa
* access.passw
Ïà¹ØÎĵµ£º
Javaѧϰ´ÓÈëÃŵ½¾«Í¨
Ò»¡¢ JDK (Java Development Kit)
JDKÊÇÕû¸öJavaµÄºËÐÄ£¬°üÀ¨ÁËJavaÔËÐл·¾³£¨Java Runtime Envirnment£©£¬Ò»¶ÑJava¹¤¾ßºÍJava»ù´¡µÄÀà¿â(rt.jar)¡£²»ÂÛʲôJavaÓ¦Ó÷þÎñÆ÷ʵÖʶ¼ÊÇÄÚÖÃÁËij¸ö°æ±¾µÄJDK¡£Òò´ËÕÆÎÕJDKÊÇѧºÃJavaµÄµÚÒ»²½¡£×îÖ÷Á÷µÄJ ......
from: http://mmblue.javaeye.com/blog/511915
package org.mmblue.common.util;
import java.util.List;
public class PageModel<T> {
// ......
ÁªÍ¨£º³¹µ×·ÅÆúORÓûÇܹÊ×Ý£¿
ÒµÄÚÈÕǰ´«³öÏûÏ¢£¬ÓÉÓÚÆ»¹û¼á³Ö·Ö³Éģʽ£¬ÁªÍ¨¸ß²ã¶ÔÓÚÒýÈëÆ»¹û̬¶ÈÒÑÎÞÔçÏȼá¾ö¡£“Ëæ×ÅÊÖ»úµÄ²»¶Ï¸üл»´ú£¬Ò»µãÓпÉÄܰüº¬µÄ¹¦ÄÜÌØ±ðÊÇÁªÍ¨¼ÓÈë¹È¸è¿ª·ÅÊÖ»úÁªÃË£¬ÔÚÊý¾Ý±£»¤ºÍ¼á¹ÌÐ×÷¼Æ»®ÍÆ×ÔÓпª·Å²Ù×÷ƽ̨ÊÖ»ú£¬ÔÚÊý¾Ý±£»¤ºÍ¼á¹ÌÐ×÷ javaµç×ÓÊéÃâ·ÑÏÂÔØiPhoneÔÚÆäÕ½ÂÔÖ ......
±¾ÎÄÊÇÓÉJRÖ÷³Öд×÷µÄ¡¶J2SE½ø½×¡·Ò»ÊéµÄ²¿·ÖÕ½ÚÕûÀí¶ø³É£¬¡¶J2SE½ø½×¡·ÕýÔÚд×÷¡¢ÍêÉÆ½×¶Î¡£ÄúÔĶÁºó£¬ÓÐÈκν¨Òé¡¢ÅúÆÀ£¬ÇëºÍÎÒÁªÏµ£¬»òÔÚhttp://www.javaresearch.org/forum/thread.jsp?column=376&thread=7576' target='_blank' class='l2'>Õâ¶ùÁôÑÔ¡£¡¶J2SE½ø½×¡·Ð´×÷ÏîÄ¿×é¸ÐлÄúÔĶÁ±¾ÎÄ¡£
ÔÚµ±½ñÕ ......