JAVAÅäÖÃJNDIÊý¾ÝÔ´
±¾°¸ÀýÊÇʹÓÃSQLSERVER2005×÷ΪÊý¾ÝÔ´£¬Ê¹ÓÃTOMCAT6.0
µÚÒ»²½£¬°ÑÒÔÏ´úÂ뿽±´µ½tomcatµÄ°²×°Ä¿Â¼confÎļþ¼Ðcontext.xmlÎļþÏ¡£
Êý¾Ý¿âÁ¬½ÓÇëÐÞ¸Ä
<Resource name="jdbc/demo"
auth="Container"
type="javax.sql.DataSource"
driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
url="jdbc:sqlserver://localhost:1433;databaseName=Demo"
username="sa"
password=""
maxActive="100"
maxIdle="30"
maxWait="10000" />
µÚ¶þ²½£¬°Ñjdbc¼Ü°ü¿½±´µ½tomcat°²×°Ä¿Â¼libÏÂ
µÚÈý²½£¬ÔÚ³ÌÐòÀïдÈçÒÔÏ´úÂë
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;
public static Connection getConn(){
Connection con=null;
try {
Context ctx=new InitialContext();
DataSource ds=(DataSource) ctx.lookup("java:comp/env/jdbc/demo");
if(ds==null){
System.out.println("Êý¾ÝÔ´²»ÕýÈ·");
}else{
con=ds.getConnection();
}
}catch (Exception e) {
// TODO Auto-generated catch block
e.getMessage();
}
return con;
}
µÚËIJ½£¬Æô¶¯tomcat²ÅÄܲâÊÔ
Ïà¹ØÎĵµ£º
Javaѧϰ´ÓÈëÃŵ½¾«Í¨
Ò»¡¢ JDK (Java Development Kit)
JDKÊÇÕû¸öJavaµÄºËÐÄ£¬°üÀ¨ÁËJavaÔËÐл·¾³£¨Java Runtime Envirnment£©£¬Ò»¶ÑJava¹¤¾ßºÍJava»ù´¡µÄÀà¿â(rt.jar)¡£²»ÂÛʲôJavaÓ¦Ó÷þÎñÆ÷ʵÖʶ¼ÊÇÄÚÖÃÁËij¸ö°æ±¾µÄJDK¡£Òò´ËÕÆÎÕJDKÊÇѧºÃJavaµÄµÚÒ»²½¡£×îÖ÷Á÷µÄJ ......
create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',
@pagesize int output,--ÿҳÏÔʾ¼Ç¼ÌõÊý
@currentpage int output,--µÚ¼¸Ò³
@orderid nvarchar(50),--Ö÷¼üÅÅÐò
@sort int,--ÅÅÐò·½Ê½£¬1±íʾÉýÐò£¬0±íʾ½µÐòÅÅÁÐ
......
Enum×÷ΪSunÈ«ÐÂÒý½øµÄÒ»¸ö¹Ø¼ü×Ö£¬¿´ÆðÀ´ºÜÏóÊÇÌØÊâµÄclass, ËüÒ²¿ÉÒÔÓÐ×Ô¼ºµÄ±äÁ¿£¬¿ÉÒÔ¶¨Òå×Ô¼ºµÄ·½·¨£¬¿ÉÒÔʵÏÖÒ»¸ö»òÕß¶à¸ö½Ó¿Ú¡£ µ±ÎÒÃÇÔÚÉùÃ÷Ò»¸öenumÀàÐÍʱ£¬ÎÒÃÇÓ¦¸Ã×¢Òâµ½enumÀàÐÍÓÐÈçϵÄÒ»Ð©ÌØÕ÷¡£
¡¡ ......
package com.xinnuo.jdbc;
import java.io.*;
import java.sql.*;
import java.util.*;
import java.util.Date;
/*
* ¸ÃÀàÖ»ÄÜ´´½¨Ò»¸öʵÀý£¬ÆäËü¶ÔÏóÄܹ»µ÷ÓÃÆä¾²Ì¬·½·¨£¨Ò²³ÆÎªÀà·½·¨£©»ñµÃ¸ÃΨһʵÀýµÄÒýÓá£
* DBConnectionManagerÀàµÄ½¨¹¹º¯ÊýÊÇ˽Óеģ¬ÕâÊÇΪÁ˱ÜÃâÆäËü¶ÔÏó´´½¨¸ÃÀ ......
×î½üÔÚCSDN£¬¿´µ½ÁËÒ»µÀȤζÌ⣺123456789Õâ¾Å¸ö°´Ë³ÐòÅÅÁеÄÊý£¬ÒªÇóÔÚËüÃÇÖ®¼ä²åÈëÈô¸É¸ö+£¬-£¬*£¬/ £¬Ê¹Æä½á¹ûÕýºÃµÈÓÚ
100È磺1*2*3*4+5+6+7*8+9=100¡£
¿´ÁËÌâÄ¿ºó£¬Ë¼¿¼Èç¹ûÓÃjavaÈçºÎʵÏÖ¡£ÒÔÏÂÊÇÎҵĽâÌâ˼·£º
˼Ïë±È½Ï¼òµ¥£¬ÏȽ«²åÈë+£¬-£¬*£¬/ºóµÄËùÓÐ×Ö·û´®¶¼Çî¾Ù³öÀ´£¬È»ºó¼ÆËãÄÄЩ×Ö·û´®µÈÓÚ100¡£
Õ ......