Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

jspÔõÑùɾ³ý²¢¸üÐÂSQL SERVER 2005µÄÊý¾Ý

ÓÃjspÑ¡ÔñÁËɾ³ýÊý¾Ýºó£¬Ê¹Êý¾Ý²»»á³öÏÖÔÚjspÒ³ÃæºÍÊý¾Ý¿âÖУ¬Ò²¾ÍÊÇÒª¸üÐÂÊý¾Ý£¬¸÷λ´óÏÀ¸ÃÔõô×ö£¿Ð»Ð»£¡£¡
index.jsp
<%@ page language="java" import="java.sql.*" pageEncoding="gb2312"%>
<html>
  <body>
    <div align="center"> <%
    Connection con;
    Statement sql;
    ResultSet rs;
    try{
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    }
    catch(ClassNotFoundException e){out.print("ÀàÕÒ²»µ½!");
    out.print(e);
    }
    try{
    con=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=user","sa","11011");
    sql=con.createStatement();
    rs=sql.executeQuery("select * from userTable");
    int row=rs.getRow();
    out.print(" <table border>");
    out.print(" <tr> <td colspan=8 align=center>Óû§Êý¾Ý(¹²"+row+"ÌõÊý¾Ý) </td> </tr>");
    out.print(" <tr>");
    out.print(" <td width=100>"+"Óû§idºÅ");
    out.print(" <td width=100>"+&


Ïà¹ØÎÊ´ð£º

sql¿ÉÒÔÓÐÁ½¸öÒÔÉϵĴ¥·¢Æ÷Â𣿣¿

sql¿ÉÒÔÓÐÁ½¸öÒÔÉϵĴ¥·¢Æ÷Â𣿣¿ÎÒÖ¸µÄÊÇfor´¥·¢Æ÷£¬ÄÇÆäËûµÄÄØ£¿£¿
ʲôÒâ˼£¿

¿ÉÒÔµÄ

10¸ö¶¼Ã»ÎÊÌâ

¿ÉÊÇÎÒдÁËÁ½¸öfor insert ´¥·¢Æ÷£¬Ôì³É½ø³Ì×èÈûÁËÄØ£¿Ôõô°ìÄØ£¿Çë¸ßÈËÖ¸µã
......

sqlת»»ÎÊÌ⣬¼±£¡ - ÉçÇøÖ§³Ö / ¡¶³ÌÐòÔ±¡·ÔÓÖ¾

select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......

jspÏà¹ØÎÊÌâ - Web ¿ª·¢ / JavaScript

ÎÒÏëµÇ¼ºó£¬Èç¹ûµÇ¼³É¹¦¾ÍÈ¥Ö´ÐÐij¸öÒ³Ãæ
ÎÒÏÖÔڵĴúÂëÊÇÕâÑùµÄ£º
if(rs.next()){
 session.setAttribute( "username" , user);
  <jsp:include page="login.jsp" />// ......

jsÔÚjspÖв»Äܵ÷ÓÃÎÊÌâ¡£

jsÖеķ½·¨£¬²»ÄÜÔÚjspÖе÷ÓÃÔõô½â¾ö£¿¼±£¡£¡!
²»Ã÷°×Òâ˼

ºÃºÃ¼ì²éÊDz»ÊÇ·¾¶µÄÎÊÌ⣬ºÜÓпÉÄÜ·¾¶²»¶Ôµ¼Öµ÷Óò»µ½

Ìùһϵ÷ÓõĴúÂë¿´¿´°¡~~
ÓÐûÓÐÕýÈ·ÒýÓÃjs£¿º¯ÊýÓÐûÓгõʼ»¯£¿....

jsp´úÂë±¾À´¾ ......

ÔÚjspÖÐÓÃsessionÔõôʵÏÖ¹ºÂò¹¦ÄÜ - Java / Web ¿ª·¢

ÎÒÏë×ö¹»¹ºÎï³µÓÃsession µ«ÊDz»ÖªµÀÔõô»ñÈ¡¹ºÂòÊýÁ¿ Ë­ÓоßÌåµÄ´úÂëÂð Ï£ÍûÄܸîÉá

ÏÂÃæÊǹºÎï³µµÄºËÐÄ´úÂë 
ÓÐÁËÕâ¸ö ¾ÍÓ¦¸ÃÄܹ»×ö³öÀ´°É
Java code:

public void doPost(HttpServletRequest reque ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ