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

JSPÁ¬½ÓSQL serverµÄÎÊÌ⣿

ÎÒʹÓõÄÊÇLINUX+RESINµÄJSP WEB·þÎñÆ÷£¬ÎÒ°ÑSQL SERVERµÄÇý¶¯£¨Èý¸öJARÎļþ£©¿½±´µ½RESIN/LIBĿ¼Ï£¬ÖØÐÂÆô¶¯LINUXϵͳ£¬±àдÁËÈçϳÌÐò£º
<%@ page contentType="text/html;charset=gbk" %>
<%@ page import="java.sql.*"%>
<%
    String dbDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
    String dbURL="jdbc:sqlserver://172.18.152.6:1433;DataBaseName=element";//ÄãÒªÁ¬½ÓµÄÊý¾Ý¿âÃû";
    String dbUser="sa";//Êý¾Ý¿âÓû§Ãû,Ò»°ãΪsa";
    String dbPassword="";//"Êý¾Ý¿âÓû§ÃÜÂë,Ò»°ãΪsa";
    Connection conn = null;
    PreparedStatement stmt= null;
    String QueryStr = null;
    ResultSet rs = null;

    try{
        Class.forName(dbDriver);
        conn = DriverManager.getConnection(dbURL,dbUser,dbPassword);
        QueryStr="select * from tabTD ORDER BY LATITUDE";
        stmt = conn.prepareStatement(QueryStr);
        String str="";
        rs=stmt.executeQuery(QueryStr);
        while(rs.next()){
            str=rs.getString("DryBulTemp");
 


Ïà¹ØÎÊ´ð£º

csvÎļþת»»³Ésqlµ¼Èëµ½Êý¾Ý¿â£¬Ã»ÓÐÊý¾ÝΪºÎ£¿

Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......

¹ØÓÚÔÚJSPÖÐÉÏ´«Í¼Æ¬µÄÏà¹ØÎÊÌâ - Web ¿ª·¢ / ÆäËû

//Óÿͻ§µÄsessionµÄid½¨Á¢Ò»¸öÁÙʱÎļþ£º
//String tempFileName=(String)session.getId();
String tempFileName = (String)session.getId();
//out.println(& ......

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

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

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

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

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

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

jsp´úÂë±¾À´¾ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ