JSPÁ¬½Ó¸÷ÖÖÊý¾Ý¿â ´úÂ뼯½õ
ÄÇôÏÖÔÚ¿ªÊ¼ÎÒÃǵÄjspºÍÊý¾Ý¿âÖ®Âðɡ£
Ò»¡¢jspÁ¬½ÓOracle8/8i/9iÊý¾Ý¿â£¨ÓÃthinģʽ£©
testoracle.jspÈçÏ£º
<%@ page contentType=\"text/html;charset=gb2312\"%>
<%@ page import=\"java.sql.*\"%>
<html>
<body>
<%Class.forName(\"oracle.jdbc.driver.OracleDriver\").newInstance();
String url=\"jdbc:oracle:thin:@localhost:1521:orcl\";
//orclΪÄãµÄÊý¾Ý¿âµÄSID
String user=\"scott\";
String password=\"tiger\";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql=\"select * from test\";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {%>
ÄúµÄµÚÒ»¸ö×Ö¶ÎÄÚÈÝΪ£º<%=rs.getString(1)%>
ÄúµÄµÚ¶þ¸ö×Ö¶ÎÄÚÈÝΪ£º<%=rs.getString(2)%>
<%}%>
<%out.print(\"Êý¾Ý¿â²Ù×÷³É¹¦£¬¹§Ï²Äã\");%>
<%rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
¶þ¡¢jspÁ¬½ÓSql Server7.0/2000Êý¾Ý¿â
testsqlserver.jspÈçÏ£º
<%@ page contentType=\"text/html;charset=gb2312\"%>
<%@ page import=\"java.sql.*\"%>
<html>
<body>
<%Class.forName(\"com.microsoft.jdbc.sqlserver.SQLServerDriver\").newInstance();
String url=\"jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs\";
//pubsΪÄãµÄÊý¾Ý¿âµÄ
String user=\"sa\";
String password=\"\";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql=\"select * from test\";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {%>
ÄúµÄµÚÒ»¸ö×Ö¶ÎÄÚÈÝΪ£º<%=rs.getString(1)%>
ÄúµÄµÚ¶þ¸ö×Ö¶ÎÄÚÈÝΪ£º<%=rs.getString(2)%>
<%}%>
<%out.print(\"Êý¾Ý¿â²Ù×÷³É¹¦£¬¹§Ï²Äã\");%>
<%rs.close();
stmt.close();
conn.close();
%>
</body>
<
Ïà¹ØÎĵµ£º
Ò» ¡£×Ô¶¨ÒåJSP±êÇ©µÄ´¦Àí¹ý³Ì£º
¡¡ 1£®ÔÚJSPÖÐÒýÈë±êÇ©¿â£º
¡¡ 2£®ÔÚJSPÖÐʹÓñêÇ©¿â±êÇ©
¡¡ 3£®WebÈÝÆ÷¸ù¾ÝµÚ¶þ¸ö²½ÖèÖеÄprefix£¬»ñµÃµÚÒ»¸ö²½ÖèÖÐÉùÃ÷µÄtaglibµÄuriÊôÐÔÖµ
¡¡ 4£®WebÈÝÆ÷¸ù¾ÝuriÊôÐÔÔÚweb.xmlÕÒµ½¶ÔÓ¦µÄÔªËØ
5£®´ÓÔªËØÖлñµÃ¶ÔÓ¦µÄÔªËصÄÖµ
6£®WebÈÝ ......
ÔÚjspÖÐʹÓÃsmartupload×é¼þÉÏ´«Îļþ
jsp¶ÔÉÏ´«ÎļþµÄÖ§³Ö²»ÏóphpÖÐÖ§³ÖµÄÄÇôºÃ£¬Ö±½Ó×ö³ÉÁ˺¯Êý£¬Ò²²»ÏóaspÖÐҪͨ¹ý×é¼þ²ÅÄÜʵÏÖ¡£jspÖпÉÒÔͨ¹ýjavabeanÀ´ÊµÏÖ¡£µ«ÊÇÎÒÃÇûÓбØÒª×Ô¼ºÈ¥Ð´Ò»¸öÉÏÔصÄbean£¬ÔÚÍøÉÏÒѾÓÐÁ˺ܶà³ÉÐ͵ļ¼Êõ£¬smartupload¾ÍÊÇÆäÖеÄÒ»¸ö¡£µ«ÊÇsmartuploadÊǽ«ÎļþÏȶÁµ ......
Web.xml³£ÓÃÔªËØ
<web-app>
<display-name></display-name>¶¨ÒåÁËWEBÓ¦ÓõÄÃû×Ö
<description></description> ÉùÃ÷WEBÓ¦ÓõÄÃèÊöÐÅÏ¢
<context-param></context-param> context-paramÔªËØÉùÃ÷Ó¦Ó÷¶Î§Äڵijõʼ»¯²ÎÊý¡£
<filter></filter> ¹ýÂËÆ÷ÔªËؽ«Ò»¸ ......
jspÂÒÂëÎÊÌâ½â¾ö
1¡¢Ò»°ãµÄjspÒ³ÃæÏÔʾÂÒÂë
<%@ page contentType="text/html; charset=UTF-8"%>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
2¡¢±íµ¥Ìá½»ÖÐÎÄʱ³öÏÖÂÒÂë
Èç¹ûjspÌá½»Ó¢ÎÄ×Ö·ûÄÜÕýÈ·ÏÔʾ£¬¶øÌá½»ÖÐÎÄʱ¾Í»á³öÏÖÂÒÂë¡£
ÔÒò£ºä ......