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
Ïà¹ØÎÊ´ð£º
ÎÒÏÖÔÚÏëÓÃsshÕûºÏÀ´×öÒ»¸öÂÛ̳£¬µ«Êý¾Ý¿â·½Ãæ²»ÐУ¬ÎÒÖ÷Òª²»»áÉæ¼°Êý¾Ý¿â£¬²»ÖªµÀ·¢Ìû±í£¬ºÍ»ØÌû±íÒªÈçºÎÉè¼ÆºÍÇø·Ö¡£²»ÖªµÀËÓÐÒ»¸ö¼òµ¥µÄ˼·£¬À´Éè¼ÆÕâЩ±í¡£Ð»Ð»ÁË¡£
·¢ÌûºÍ»ØÌûÓÃͬһÕÅ±í ¡£·¢Ìû id user ......
ÏÂÃæcategoryTreeCont.jsp ´úÂë
----------------------------------------
Java code:
<%@ page language="java" import="java.util.*" pageEncoding="gbk"%>
< ......
ÎÒÏëµÇ¼ºó£¬Èç¹ûµÇ¼³É¹¦¾ÍÈ¥Ö´ÐÐij¸öÒ³Ãæ
ÎÒÏÖÔڵĴúÂëÊÇÕâÑùµÄ£º
if(rs.next()){
session.setAttribute( "username" , user);
<jsp:include page="login.jsp" />// ......
<%@page language="java" contentType="text/html;charset=gb2312" import="java.sql.*"%>
<jsp:useBean id="db" class="wang.connectDB"/>
< ......
jsÖеķ½·¨£¬²»ÄÜÔÚjspÖе÷ÓÃÔõô½â¾ö£¿¼±£¡£¡!
²»Ã÷°×Òâ˼
ºÃºÃ¼ì²éÊDz»ÊÇ·¾¶µÄÎÊÌ⣬ºÜÓпÉÄÜ·¾¶²»¶Ôµ¼Öµ÷Óò»µ½
Ìùһϵ÷ÓõĴúÂë¿´¿´°¡~~
ÓÐûÓÐÕýÈ·ÒýÓÃjs£¿º¯ÊýÓÐûÓгõʼ»¯£¿....
jsp´úÂë±¾À´¾ ......