JSPÊÇÈçºÎµ÷Óô洢¹ý³ÌµÄ£¨ÔÚÏߵȣ©
µ¥Î»ÓõÄjsp£¬µ«ÊÇÎÒ²»ÖªµÀjspÔõôµ÷Óô洢¹ý³Ì
Äܸø³öÀý×Ó´úÂë×îºÃÀ²~
»¹ÓоÍÊǵ÷ÓõÄÊÇ´æ´¢¹ý³ÌÃû³ÆÄØ£¿»¹Êǵ÷Óô洢¹ý³ÌÀïÃæ¶¨ÒåµÄ±äÁ¿ÄØ£¿
ÔÚÏߵȻظ´Å¶
±ð³ÁÁË¡£¡£×ż±Á¨
²Î¿¼ÈçÏ´úÂ룺
javax.sql.DataSource ds = (javax.sql.DataSource) ctx
.lookup("mslv/oms/oms1/internal/jdbc/DataSource");
conn = ds.getConnection();
String sql = "{call PAL_ACTIVATION_ADAPT.GET_97_USERID_SERIALID(?,?,?,?,?)}";
cstmt = conn.prepareCall(sql);
cstmt.setString(1, this.serialNoRA);
cstmt.registerOutParameter(2, Types.VARCHAR);
cstmt.registerOutParameter(3, Types.VARCHAR);
cstmt.registerOutParameter(4, Types.INTEGER);
cstmt.registerOutParameter(5, Types.VARCHAR);
cstmt.execute();
this.userId = (cstmt).getString(2);
this.serialNo97 = (cstmt).getString(3);
this.nerr_Statement = (cstmt).getInt(4);
this.serr_Statement = (cstmt).getString(5);
http://blog.csdn.net/moonsbird/archive/2007/10/11/1819513.aspx
Ïà¹ØÎÊ´ð£º
ÎÒÔÚʹÓÿªÔ´µÄJXL ³öEXCEL±¨±íʱÓöµ½ÕâÑùµÄÎÊÌâ¡£
ÎÒÏë³öµÄÎļþÃû³ÆÊÇÕâÑùµÄ£ºÀý£ºtest_ÀîÇ¿.xls
´úÂëÊÇ ....test_+"UserID"+".xls";
µ«ÊÇ¿ØÖÆÌ¨ÎÒ¿´µ½µÄÊä³öÃû³ÆÐ§¹ûÊÇ£ºtest_µ ......
//Óÿͻ§µÄsessionµÄid½¨Á¢Ò»¸öÁÙʱÎļþ£º
//String tempFileName=(String)session.getId();
String tempFileName = (String)session.getId();
//out.println(& ......
<%@page language="java" contentType="text/html;charset=gb2312" import="java.sql.*"%>
<jsp:useBean id="db" class="wang.connectDB"/>
< ......
jsÖеķ½·¨£¬²»ÄÜÔÚjspÖе÷ÓÃÔõô½â¾ö£¿¼±£¡£¡!
²»Ã÷°×Òâ˼
ºÃºÃ¼ì²éÊDz»ÊÇ·¾¶µÄÎÊÌ⣬ºÜÓпÉÄÜ·¾¶²»¶Ôµ¼Öµ÷Óò»µ½
Ìùһϵ÷ÓõĴúÂë¿´¿´°¡~~
ÓÐûÓÐÕýÈ·ÒýÓÃjs£¿º¯ÊýÓÐûÓгõʼ»¯£¿....
jsp´úÂë±¾À´¾ ......