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ÓïÑÔ½¨Á¢Ò»Ì×¶àÏ̷߳þÎñÆ÷µÄ¹ý³Ì£¬¸Ã·þÎñÆ÷ʹÓöÔÏó´«µÝÏûÏ¢£¬ÔÚÏß³ÌÖÐʹÓöÓÁлúÖÆ£¬Ê¹·þÎñÆ÷µÄÐÔÄÜ´ó´óÌá¸ßÁË¡£ÕâÌ×·þÎñÆ÷¿ÉÒÔ±»ÓÃÓÚ¸÷ÖÖC/S»òB/S½á¹¹µÄÓ¦ÓóÌÐòÖС£
JavaÓïÑÔÊÇÍêÈ«ÃæÏò¶ÔÏó
µÄ£¬ËüµÄÏ̻߳úÖÆºÍ¶ÔÏóÐòÁл¯ÌرðÈÝÒ×ʹÓã¬Ê¹ÓÃJavaÀ´½¨Á¢Ò»Ì×¶àÏ̷߳þÎñÆ÷Òª±ÈʹÓÃÆäËüÓï ......
package com.xinnuo.jdbc;
import java.io.*;
import java.sql.*;
import java.util.*;
import java.util.Date;
/*
* ¸ÃÀàÖ»ÄÜ´´½¨Ò»¸öʵÀý£¬ÆäËü¶ÔÏóÄܹ»µ÷ÓÃÆä¾²Ì¬·½·¨£¨Ò²³ÆÎªÀà·½·¨£©»ñµÃ¸ÃΨһʵÀýµÄÒýÓá£
* DBConnectionManagerÀàµÄ½¨¹¹º¯ÊýÊÇ˽Óеģ¬ÕâÊÇΪÁ˱ÜÃâÆäËü¶ÔÏó´´½¨¸ÃÀ ......
--°ü
create or replace package pkg_query as
type cur_query is ref cursor;
end pkg_query;
--¹ý³Ì
CREATE OR REPLACE PROCEDURE "PRC_QUERY" (p_tableName
in varchar2, --±íÃû
& ......
javaʹÓÃMathÀ࣬phpʹÓÃϵͳº¯Êý
ceil¹¦ÄÜ ´óÓÚµÈÓÚijÊý(³£ÓÃÓÚ·ÖÒ³Ò³Êý¼ÆË㣩
phpÖУºceil(a/b)
javaÖУº(int)Math.ceil((double)a/b)) Math.ceilÔÚjavaÖÐÐèÒª´«ÈëdoubleÐÍ£¬¶ø·µ»ØÒ²ÊÇdoubleÐÍ¡£×¢ÒâÕâÀïÓÃ(double)a/b²Å¿ÉÒÔ¡£
a/b,(dobule)(a/b)¶¼²»ÐС£ÒòΪËûÃÇ»áÏÈ×Ô¶¯ÉáÆúСÊýÈ¡µÃÕûÊý
flooe ......
¼¦ÍÃͬÁýÎÊÌâ¾ÍÊǶþÔªÒ»´Î·½³Ì×飬¸ßµÈÊýѧÀïÃæÓÃÐÐÁÐʽÀ´½â´Ë·½³Ì¡£¾ßÌå¹ý³Ì¿É Google “ÐÐÁÐʽ ¶þÔªÒ»´Î·½³Ì×é
”¡£¶ÔÓÚ¼¦ÍÃͬÁýÎÊÌ⻹Ҫ¼ÓÉÏÒ»¸öÏÞÖÆ£º·½³ÌµÄ½â±ØÐëÊÇÕýÕûÊý¡£
ÏÂÃæÊÇ´úÂëʾÀý£º
/**
* ¼¦ÍÃͬÁýÎÊÌâ¡£½â·¨Çë Google£º“ÐÐÁÐʽ ¶þÔªÒ»´Î·½³Ì×é”
*
* @author yiding.he
*/ ......