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");
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......
//Óÿͻ§µÄsessionµÄid½¨Á¢Ò»¸öÁÙʱÎļþ£º
//String tempFileName=(String)session.getId();
String tempFileName = (String)session.getId();
//out.println(& ......
ÎÒÏëµÇ¼ºó£¬Èç¹ûµÇ¼³É¹¦¾ÍÈ¥Ö´ÐÐij¸öÒ³Ãæ
ÎÒÏÖÔڵĴúÂëÊÇÕâÑùµÄ£º
if(rs.next()){
session.setAttribute( "username" , user);
<jsp:include page="login.jsp" />// ......
jsÖеķ½·¨£¬²»ÄÜÔÚjspÖе÷ÓÃÔõô½â¾ö£¿¼±£¡£¡!
²»Ã÷°×Òâ˼
ºÃºÃ¼ì²éÊDz»ÊÇ·¾¶µÄÎÊÌ⣬ºÜÓпÉÄÜ·¾¶²»¶Ôµ¼Öµ÷Óò»µ½
Ìùһϵ÷ÓõĴúÂë¿´¿´°¡~~
ÓÐûÓÐÕýÈ·ÒýÓÃjs£¿º¯ÊýÓÐûÓгõʼ»¯£¿....
jsp´úÂë±¾À´¾ ......