Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ת»»ÎÊÌ⣬¼±£¡ - ÉçÇøÖ§³Ö / ¡¶³ÌÐòÔ±¡·ÔÓÖ¾

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 ÖÐÂÒÂëµÄ - Java / Web ¿ª·¢

ÎҵĿª·¢µÄƽ̨ÊÇMyeclipes6.0 + tomcat5.x + mysql
ÎÒËùÓеıàÂ뷽ʽ¶¼ÊÇÓõÄUTF-8 
ÎÒÖ»ÓÃÁËStrtus¿ò¼Ü
ÔÚÒ»¸öformÖÐÈçÏÂÓõÄÊÇpostµÄÌá½»·½Ê½£º
 <form class="form" action=&quo ......

¹ØÓÚSQLSERVERµ×²ãÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»


ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡

¹Ø×¢¡«¡«

Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......

´ÓORACLEµ½DB2µÄSQLÓï¾äÎÊÌâ

ÏÖÔÚÓÐÒ»ORACLEÖеÄSQLÓï¾ä£¬ÐèÒªÒÆÖ²µ½DB2ÖУ¬ÇëÎʸÃSQL¸ÄÈçºÎд
ORACLEÖУº
select floor(months_between(date1,date2)) from A  
date1,date2·Ö±ðΪ±íÖеÄÁ½¸ö×Ö¶Î £¬¶¼ÎªÈÕÆÚÐÍ 
DB2ÖÐÈçºÎʹÓÃÐ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ