Èç½ñСµÜÓöµ½ÈçÏÂÎÊÌ⣬ÀûÓÃlast()·½·¨£¬µÃµ½ÒƵ½×îºóÒ»ÐС£È»¶ø£¬Í¬Ñù´úÂë¶¼ÔÚMyEclipseÖУ¬ÔÚ²»Í¬µÄÏîÄ¿ÖУ¬Ò»¸öÄÜÖ´ÐУ¬ÁíÒ»¸ö²»ÄÜÖ´ÐУ¬ÎªÊ²Ã´£¿£¨¿ÉÒÔÁ¬½Óµ½Êý¾Ý¿â£¬²¢²éѯµ½Êý¾Ý)
public ResultSet ExecuteSELECT(String sql) throws SQLException
{
try
{
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=stmt.executeQuery(sql);
}
catch(SQLException ex)
{System.err.println(ex.getMessage());}
return rs;
}
ConnectDatabase conn=new ConnectDatabase();
conn.GetConnection();
String sql="select * from ware";
ResultSet rs=conn.ExecuteSELECT(sql);
if(rs.last())
out.print("success");
else
out.print("lost");
ÎÊÌ⣺javax.servlet.ServletException: com.microsoft.sqlserver.jdbc.SQLServerException: Ö»½ø½á¹û¼¯²»Ö§³ÖÇëÇóµÄ²Ù×÷¡£
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:852)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:781)
org.apache.jsp.shop.sort.MyJsp_jsp._jspService(MyJsp_jsp.java:113)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
<%@page language="java" contentType="text/html;charset=gb2312" import="java.sql.*"%>
<jsp:useBean id="db" class="wang.connectDB"/>
< ......
ÎÒÏë×ö¹»¹ºÎï³µÓÃsession µ«ÊDz»ÖªµÀÔõô»ñÈ¡¹ºÂòÊýÁ¿ ËÓоßÌåµÄ´úÂëÂð Ï£ÍûÄܸîÉá
ÏÂÃæÊǹºÎï³µµÄºËÐÄ´úÂë
ÓÐÁËÕâ¸ö ¾ÍÓ¦¸ÃÄܹ»×ö³öÀ´°É
Java code:
public void doPost(HttpServletRequest reque ......
Ò»¸öJSPÒ³Ãæ½ÓÊÕÆäËûÒ³ÃæÌá½»¹ýÀ´µÄFORM±íµ¥£¬µ«ÊÇÒªÇóÖ»½ÓÊÕµ±Ç°Õ¾µã¼°Æä×ÓÕ¾µãÌá½»¹ýÀ´µÄFORM±íµ¥£¬ÆäËûÕ¾µãÌá½»¹ýÀ´µÄ±íµ¥²»½ÓÊÕ£¬Õâ¸öÔõôÉèÖã¿
ÓùýÂËÆ÷
filter
½«µ±Ç°Õ¾µã¼°Æä×ÓÕ¾µã·ÅÒ»¸öĿ¼
È» ......
Ò»¸öÃû³Æ,ÐèÒªÊäÈëµÄ£¬Ò»¸öÏÂÀ²Ëµ¥£¬Ñ¡ÔñµÄ£¬¸ù¾ÝÕâÁ½¸ö½øÐÐÄ£ºý²éѯ¡£ÔÚ·þÎñÆ÷¶ËÎÞÂÛÊäÈëÓë·ñ£¬¶¼Äܵóö²éѯ½á¹û¡£
µ«ÊÇ·ÃÎʵϰ£¬Ö»ÓÐÔÚÊäÈëÃû³ÆµÄʱºò£¬ÔÙÑ¡ÔñÏÂÀ²Ëµ¥²ÅÄܲéѯ£¬Èô²»ÊäÈëÃû³Æ£¬Ö»Ñ¡ÔñÏÂÀ²Ëµ ......