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
Ïà¹ØÎĵµ£º
create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',
@pagesize int output,--ÿҳÏÔʾ¼Ç¼ÌõÊý
@currentpage int output,--µÚ¼¸Ò³
@orderid nvarchar(50),--Ö÷¼üÅÅÐò
@sort int,--ÅÅÐò·½Ê½£¬1±íʾÉýÐò£¬0±íʾ½µÐòÅÅÁÐ
......
JavaÍøÂç±à³Ì³õ²½
Kagula
2009-11-23
¹Ø¼ü´Ê
Java Socket DataInputStream DataOutputStream
¸ÅÒª
ʹÓÃJavaͬ²½IOÓ¦ÓóÌÐò¿â£¬ÊµÏÖCS½á¹¹ÍøÂç±à³Ì¡£
ÕýÎÄ
ʹÓÃSocketÀ´½¨Á¢ÍøÂçÁ¬½Ó£¬Ê¹ÓÃDataInputStream¡¢DataOutputStreamÀ´´æÈ¡ÍøÂçÁ÷¡£
¿Í»§¶Ë²¿·Ý
µÚÒ»²½ ......
Ê®½øÖÆ×ª³ÉÊ®Áù½øÖÆ£º
Integer.toHexString(int i)
Ê®½øÖÆ×ª³É°Ë½øÖÆ
Integer.toOctalString(int i)
Ê®½øÖÆ×ª³É¶þ½øÖÆ
Integer.toBinaryString(int i)
Ê®Áù½øÖÆ×ª³ÉÊ®½øÖÆ
Integer.valueOf("FFFF",16).toString()
°Ë½øÖÆ×ª³ÉÊ®½øÖÆ
Integer.valueOf("876",8).toString()
¶þ½øÖÆ×ªÊ®½øÖÆ
Intege ......
/*import javax.swing.JFrame;*/
/*import javax.swing.JOptionPane;*/
public class TestFrame{
public static void main(String[] args) throws Exception{
/*JFrame frame1 = new JFrame();
frame1.setTitle("Windows 1");
frame1.setSize(200,150);
frame1.setLocation(200,100);
frame1.setD ......
±¾ÎÄÊÇÓÉJRÖ÷³Öд×÷µÄ¡¶J2SE½ø½×¡·Ò»ÊéµÄ²¿·ÖÕ½ÚÕûÀí¶ø³É£¬¡¶J2SE½ø½×¡·ÕýÔÚд×÷¡¢ÍêÉÆ½×¶Î¡£ÄúÔĶÁºó£¬ÓÐÈκν¨Òé¡¢ÅúÆÀ£¬ÇëºÍÎÒÁªÏµ£¬»òÔÚhttp://www.javaresearch.org/forum/thread.jsp?column=376&thread=7576' target='_blank' class='l2'>Õâ¶ùÁôÑÔ¡£¡¶J2SE½ø½×¡·Ð´×÷ÏîÄ¿×é¸ÐлÄúÔĶÁ±¾ÎÄ¡£
ÔÚµ±½ñÕ ......