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 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, --±íÃû
& ......
¡¡finalÀࣺΪ·ÀÖ¹ËûÈË´ÓÄãµÄÀàÉÏÅÉÉúÐÂÀ࣬´ËÀàÊDz»¿ÉÀ©Õ¹µÄ¡£
¡¡¡¡¶¯Ì¬µ÷ÓñȾ²Ì¬µ÷Óû¨·ÑµÄʱ¼äÒª³¤¡£
¡¡¡¡³éÏóÀࣺ¹æ¶¨Ò»¸ö»ò¶à¸ö³éÏó·½·¨µÄÀà±¾Éí±ØÐ붨ÒåΪabstract¡£
¡¡¡¡Àý£º public abstract string getDescripition
¡¡¡¡JavaÖеÄÿһ¸öÀà¶¼ÊÇ´ÓObjectÀàÀ©Õ¹¶øÀ´µÄ¡£
¡¡¡¡objectÀàÖеÄequalºÍtoString·½·¨¡ ......
Õâ¸öÎÊÌâ½ñÌìÖÕÓÚ¿´Ò»¸ö¸çÃǶùµÄÎÄÕ¸㶨ÁË£¬ÔÚ´Ëлл£¡ËùÒÔ×ªÔØÒ»ÏÂ
=============================================================
java-package°üµÄʹÓ÷½·¨
¡¡¡¡
µ±Ò»¸ö´óÐͳÌÐò½»ÓÉÊý¸ö²»Í¬µÄ³ÌÐòÈËÔ±¿ª·¢Ê±£¬Óõ½ÏàͬµÄÀàÃûÊǺÜÓпÉÄܵģ¬ÄÇôÈç¹û·¢ÉúÁËÕâÑùµÄʼþÎÒÃǸÃÔõô°ìÄÇ£¿£¬ÔÚÎÒÃÇjava³ÌÐò¿ª ......
java£¨jsp)ʹÓÃMySqlÊý¾Ý¿â,ÖÐÎÄÂÒÂëµÄÍêÕû½â¾ö·½°¸
mysqlÊÇÒ»¸öСÐ͵ĿªÔ´µÄÊý¾Ý¿â£¬ÓÃÀ´×ÔѧһЩ¼¼ÊõÊÇÊ®·Ö·½±ãµÄ¡£µ«Ê¹ÓÃmysql´æ´¢Êý¾Ý£¬Ò²»áÓöµ½Ò»Ð©·Ç³£¶ñÐĵÄÎÊÌ⣬È磺ÖÐÎÄÂÒÂëÎÊÌâ¡¢javaÇý¶¯³ÌÐòÎÞ·¨Ê¹ÓõÄÎÊÌ⣨ÒѾ½â¾ö£¬Ïê¼û£ºhttp://hi.baidu.com/lauo1988/blog/item/ff0da655bd3e2eceb745ae0b.html)¡£
......