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>"+&
Ïà¹ØÎÊ´ð£º
´ó¼Ò°ïæ¿´¿´Õâ2¸ösqlÓï¾äÄĸö²éѯµÄËٶȸü¿ìµã¡£Ð»Ð»°ïæ¡£±È½Ï׿±¡£ÔÚ×öÐÔÄܲâÊÔ¡£
select * from
±íA LEFT OUTER JOIN ±íB ON (±íA.id || ' ' =±íB.id) ,±íC , ±íD, ±íE
WhereÆäËûÌõ¼þ
select * ......
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......
ÎÒÊÇÓÃSTRUTS £¬×öÁËÒ»¸öJSPÒ³Ãæ£¬Ìá½»ºóûÓдæÈëÊý¾Ý¿â¡£
JSP´úÂëÈçÏ£º
aa.jsp´úÂë
<%@ page contentType="text/html;charset=gb2312" language="java"%>
<%@ taglib uri=" ......
¼±ÓÃлл´ó¼ÒÁË ÇëËÙ»ØÌû×Ó
www.sharejs.com
ÕâÊǸöjavascript ÍøÕ¾
È¥ÀïÃæÕÒÕÒ js ÌØÐ§£¬cssÑùʽ£¬¶¼ºÜ²»´íµÄ¡£
ÓÃÔÚ×Ô¼ºµÄjspÉÏ ºÜ˧µÄ¡£
ÎÒ×Ô¼º¿ª·¢µÄ¼¸¸öjspÒ³Ãæ¶¼ÓÃÁËÉÏÃæµÄÌØÐ§ºÜºÃ£¬
½Ó·Ö£¬ÔÞ£¡ ......
ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»
ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡
¹Ø×¢¡«¡«
Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......