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>"+&
Ïà¹ØÎÊ´ð£º
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......
ÎҵĿª·¢µÄƽ̨ÊÇMyeclipes6.0 + tomcat5.x + mysql
ÎÒËùÓеıàÂ뷽ʽ¶¼ÊÇÓõÄUTF-8
ÎÒÖ»ÓÃÁËStrtus¿ò¼Ü
ÔÚÒ»¸öformÖÐÈçÏÂÓõÄÊÇpostµÄÌá½»·½Ê½£º
<form class="form" action=&quo ......
ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»
ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡
¹Ø×¢¡«¡«
Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......
ÏÖÔÚÓÐÒ»ORACLEÖеÄSQLÓï¾ä£¬ÐèÒªÒÆÖ²µ½DB2ÖУ¬ÇëÎʸÃSQL¸ÄÈçºÎд
ORACLEÖУº
select floor(months_between(date1,date2)) from A
date1,date2·Ö±ðΪ±íÖеÄÁ½¸ö×Ö¶Î £¬¶¼ÎªÈÕÆÚÐÍ
DB2ÖÐÈçºÎʹÓÃÐ ......