ÈëÃÅÎÊÌâJSP·ÃÎÊÊý¾Ý¿âΪʲôÎÞ·¨ÕýÈ·ÏÔʾ--ÔÚÏßµÈ
Êý¾Ý¿âÖÐÓÐÁ½ÏµÚÒ»ÏîÊÇÕûÐÍ£¬µÚ¶þÏîÊÇ×Ö·ûÐÍ¡£µÚÒ»ÏîµÄ±íÊÇ1ºÍ2£¬µÚ¶þÏîµÄ±íÊÇ"ÎÒÏë˵£¬abc"ºÍ"µÚ¶þ¸öÌû×Ó" ¡£´òÓ¡Ó¦¸ÃÏÔʾ
1 ÎÒÏë˵£¬abc 2 µÚ¶þ¸öÌû×Ó
¿ÉÊDz»ÖªµÀΪʲôµÚÒ»´ÎË¢ÐÂÖ»ÏÔʾ
1 ÎÒÏë˵£¬abc
µÚ¶þ´Î²ÅÏÔʾ
1 ÎÒÏë˵£¬abc 2 µÚ¶þ¸öÌû×Ó
Ô´´úÂëÈçÏÂ
<%@ page language="java" import="java.util.*" pageEncoding="GB2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<body>
<%
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String url="jdbc:sqlserver://localhost:1430;DatabaseName=stu";
String user="sa";
String password="123";
Connection conn=null;
conn=DriverManager.getConnection(url,user,password);
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY) ;
String sql="select * from bbs";
ResultSet rs= stmt.executeQuery(sql);
while(rs.next()){
out.println(rs.getInt(1));
out.println(rs.getString(2));
}
%>
</body>
</html>
ÊDz»ÊÇÑÛ»¨ÁËɶµÄ¡£¡£
²»ÊÇ£¬Ö»ÓеÚÒ»´ÎˢеÄʱºò£
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃSTRUTS £¬×öÁËÒ»¸öJSPÒ³Ãæ£¬Ìá½»ºóûÓдæÈëÊý¾Ý¿â¡£
JSP´úÂëÈçÏ£º
aa.jsp´úÂë
<%@ page contentType="text/html;charset=gb2312" language="java"%>
<%@ taglib uri=" ......
ÎÒÏëÓÃjavabeanʵÏÖ¼ÆÊý
´úÂëÈçÏ£º
ComputerCount.java
package tom.jiafei;
import java.io.*;
public class ComputerCount{
int number=0;
boolean iscome=false;
File file=new ......
ÎÒÏë×ö¹»¹ºÎï³µÓÃsession µ«ÊDz»ÖªµÀÔõô»ñÈ¡¹ºÂòÊýÁ¿ ËÓоßÌåµÄ´úÂëÂð Ï£ÍûÄܸîÉá
ÏÂÃæÊǹºÎï³µµÄºËÐÄ´úÂë
ÓÐÁËÕâ¸ö ¾ÍÓ¦¸ÃÄܹ»×ö³öÀ´°É
Java code:
public void doPost(HttpServletRequest reque ......
HTML code:
<%@ page language="java" import="java.util.*,com.test.model.*" pageEncoding="gb2312"%>
<%
String path = request.getContextPath();
String basePa ......