我的类:
public void doPost(HttpServletRequest request,HttpServletResponse response)throws ServletException, IOException
{
String username = request.getParameter("username");
String password = request.getParameter("password");
String strSql = "{call login(??)}";
CallableStatement cs = con.prepareCall(strSql);
cs.setString(1,username);
cs.setString(2,password);
ResultSet rst = cs.executeQuery();
if(rst.next())
{
RequestDispatcher rd = request.getRequestDispatcher("/welcome.jsp");
rd.forward(request, response);
}
else
{
RequestDispatcher rd = request.getRequestDispatcher("/index.jsp");
rd.forward(request, response);
}
rst.close();
}
}报的错是:D:\Tomcat\webapps\TestServlet\WEB-INF\classes\LoginServlet.java:37: unreported exception java.sql.SQLException; must be caught or declared to be thrown
CallableStatement cs = con.prepareCall(strSql);
^
D:\Tomcat\webapps\TestServlet\WEB-INF\classes\LoginServlet.java:38: unreported exception java.sql.SQLException; must be caught or declared to be thrown
cs.setString(1,username);
^
D:\Tomcat\webapps\TestServlet\WEB-INF\classes\LoginServlet.java:39: unreported exception java.sql.SQLException; must be caught or declared to be thrown
cs.setString(2,password);
^
D:\Tomcat\webapps\TestServlet\WEB-INF\classes\LoginServlet.java:41: unreported exception java.sql.SQLException; must be caught or declared to be thrown
ResultSet rst = cs.executeQuery();
^
D:\Tomcat\webapps\TestServlet\WEB-INF\classes\LoginServlet.java:43: unreported exception java.sql.SQLException; must be caught or declared to be thrown
if(rst.next())
^
D:\Tomcat\webapps\TestServlet\WEB-INF\classes\LoginServlet.java:53: unreported exception java.sql.SQLException; must be caught or declared to be thrown
rst.close();
^
6 errors
public void doPost(HttpServletRequest request,HttpServletResponse response)throws ServletException, IOException
{
String username = request.getParameter("username");
String password = request.getParameter("password");
String strSql = "{call login(??)}";
CallableStatement cs = con.prepareCall(strSql);
cs.setString(1,username);
cs.setString(2,password);
ResultSet rst = cs.executeQuery();
if(rst.next())
{
RequestDispatcher rd = request.getRequestDispatcher("/welcome.jsp");
rd.forward(request, response);
}
else
{
RequestDispatcher rd = request.getRequestDispatcher("/index.jsp");
rd.forward(request, response);
}
rst.close();
}
}报的错是:D:\Tomcat\webapps\TestServlet\WEB-INF\classes\LoginServlet.java:37: unreported exception java.sql.SQLException; must be caught or declared to be thrown
CallableStatement cs = con.prepareCall(strSql);
^
D:\Tomcat\webapps\TestServlet\WEB-INF\classes\LoginServlet.java:38: unreported exception java.sql.SQLException; must be caught or declared to be thrown
cs.setString(1,username);
^
D:\Tomcat\webapps\TestServlet\WEB-INF\classes\LoginServlet.java:39: unreported exception java.sql.SQLException; must be caught or declared to be thrown
cs.setString(2,password);
^
D:\Tomcat\webapps\TestServlet\WEB-INF\classes\LoginServlet.java:41: unreported exception java.sql.SQLException; must be caught or declared to be thrown
ResultSet rst = cs.executeQuery();
^
D:\Tomcat\webapps\TestServlet\WEB-INF\classes\LoginServlet.java:43: unreported exception java.sql.SQLException; must be caught or declared to be thrown
if(rst.next())
^
D:\Tomcat\webapps\TestServlet\WEB-INF\classes\LoginServlet.java:53: unreported exception java.sql.SQLException; must be caught or declared to be thrown
rst.close();
^
6 errors
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货