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

JSPÁ¬½ÓSQL SERVER 2008 ÕÒ²»µ½Çý¶¯

ÄÄλ¸ßÊÖÄܰïÎÒ¿´ÏÂΪʲôÅ׳öÕâЩÒì³££¿
´úÂë
<%@ page language="java" import="java.util.*" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="GB2312"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<jsp:directive.page import="java.lang.Class"/>
<jsp:directive.page import="java.sql.DriverManager"/>
<jsp:directive.page import="java.sql.Connection"/>
<jsp:directive.page import="java.sql.Statement"/>
<jsp:directive.page import="java.sql.ResultSet"/>
<html>
 <head>
  <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
  <title>SQL Server 2008</title>
 </head>
 <body topmargin="0">
  <%
  out.println("hello");
  String driverClass="com.microsoft.jdbc.sqlserver.SQLServerDriver";
  String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=JSP_TEST";
  String username="DONGJIN";
  String password="dongjin";
  try
  {
   Class.forName(driverClass);
  }
  catch(ClassNotFoundException e)
  {
   out.println("------ÔÚ¼ÓÔØÊý¾Ý¿âÇý¶¯Ê±Å׳öÒì³££¬ÄÚÈÝÈçÏ£º");
   e.printStackTrace();
  }
  Connection conn=DriverManager.getConnection(url,username,password); //½¨Á¢Á¬½Ó
  Statement stmt=conn.createStatement();  //´´½¨Á¬½Ó״̬
  ResultSet rs=stmt.executeQuery("select * from table1"); //Ö´ÐÐselectÓï¾ä
  %>
  <tr>
   <td align="center">
    <table width="30%" bordercolor="#00CC66" border="1">
     <tr align="center" bgcolor="#FF6633">
      <td>±àºÅ</td>
 &nb


Ïà¹ØÎĵµ£º

תÌû sqlË÷Òý½á¹¹

Ò»¡¢ÉîÈëdz³öÀí½âË÷Òý½á¹¹
ʵ¼ÊÉÏ£¬Äú¿ÉÒÔ°ÑË÷ÒýÀí½âΪһÖÖÌØÊâµÄĿ¼¡£Î¢ÈíµÄSQL SERVERÌṩÁËÁ½ÖÖË÷Òý£º¾Û¼¯Ë÷Òý£¨clustered index£¬Ò²³Æ¾ÛÀàË÷Òý¡¢´Ø¼¯Ë÷Òý£©ºÍ·Ç¾Û¼¯Ë÷Òý£¨nonclustered index£¬Ò²³Æ·Ç¾ÛÀàË÷Òý¡¢·Ç´Ø¼¯Ë÷Òý£©¡£ÏÂÃæ£¬ÎÒÃǾÙÀýÀ´ËµÃ÷һϾۼ¯Ë÷ÒýºÍ·Ç¾Û¼¯Ë÷ÒýµÄÇø±ð£º
Æäʵ£¬ÎÒÃǵĺºÓï×ÖµäµÄÕýÎı¾Éí¾ ......

Jsp WEBϵͳµÇ¼ÓëÓò¿Ø

ÃæµÄÉϱã»áµ¯³öÓò¿ØÑéÖ¤µÄ
¸÷λ,ÉÏ´ÎÔÚȺÖÐÎʵ½¹ØÓÚJsp WEBϵͳµÇ¼ÓëÓò¿Ø½áºÏ×öÓû§ÑéÖ¤µÄÎÊÌâ,ÏÖÔÚÒѾ­½â¾ö,½«½â¾ö°ì·¨Óë¸÷λ·ÖÏíÏÂ:
½â¾ö·½°¸:ʹÓÃsamba×éÖ¯µÄ¿ªÔ´ÏîÄ¿jCIFS
ÏîÄ¿Ê×Ò³:http://jcifs.samba.org/
²Î¿¼×ÊÁÏ:
ʹÓÃjcifs.jar¿ÉÒԷdz£ºÃʵÏÖ£¬ÏÂÔØÒ»¸ö×îеÄjcifs.jar£¬·Åµ½WEB-INFlibÏÂÃæ£¬È»ºóÐÞ¸Ä ......

5ÔÂ19ÈÕ JSP»ù´¡

1.essionÄڵĴæ·ÅµÄÊǶÔÏóµÄÒýÓÃ,ËùÒÔÐÞ¸ÄÄÚÖöÔÏóºó,²»ÐèÒªÖØÐ·ÅÖõ½sessionÖÐ
2.ÅäÖÃContext³õʼ»¯²ÎÊý
<Context-param>
<param-name></paran-name>
<param-value></param-value>
<Context-param>
this.getServletContext().getInitParameter(arg0);
--------------------- ......

SQL Ñ­»·

declare @i int
set @i=1
while @i<30
begin
insert into test (userid) values(@i)
set @i=@i+1
end
---------------
while Ìõ¼þ
begin
Ö´ÐвÙ×÷
set @i=@i+1
end
WHILE
ÉèÖÃÖØ¸´Ö´ÐÐ SQL Óï¾ä»òÓï¾ä¿éµÄÌõ¼þ¡£Ö»ÒªÖ¸¶¨µÄÌõ¼þÎªÕæ£¬¾ÍÖØ¸´Ö´ÐÐÓï¾ä¡£¿ÉÒÔʹÓà BREAK ºÍ CONTINUE ¹Ø¼ü×ÖÔÚÑ­»·ÄÚ²¿¿ØÖÆ W ......

SQL°´ÕÕÈÕ¡¢ÖÜ¡¢Ô¡¢Äêͳ¼ÆÊý¾Ý

Èç: ±í:consume_record 
×Ö¶Î:consume (moneyÀàÐÍ)  date (datetimeÀàÐÍ) 
ÇëÎÊÔõôдËÄÌõsqlÓï¾ä·Ö±ð°´ÈÕ,°´ÖÜ,°´ÔÂ,°´¼¾Í³¼ÆÏû·Ñ×ÜÁ¿. 
Èç:1Ô 1200Ôª 
2Ô 3400Ôª 
3Ô 2800Ôª 
--°´ÈÕ 
select sum(consume),day([date]) from& ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ