这是DAOpackage dao;import java.sql.*;
import MyException.BadLoginException;
public class LoginDAO {
private Connection con=null;
// private ResultSet rs=null;
public LoginDAO() {
getConnection();
} private Connection getConnection(){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
System.out.println("====================>");
con=DriverManager.getConnection("jdbc:odbc:notepad","","");
System.out.println("======================>>>");
}catch(Exception e){
System.out.println("==================================>>>>>>>>>>>");
e.printStackTrace();
}
return con;
} public void unLogin(String userName,String passWord)throws BadLoginException{
try{
System.out.println("=============================1");
PreparedStatement pstmt = con.prepareStatement(
"select * from login where userNmae=? and passWord=?");
pstmt.setString(1,userName);
pstmt.setString(2,passWord);
System.out.println("==============================2"+userName+"::::::"+passWord);
ResultSet rs=pstmt.executeQuery();
System.out.println("==============================3");
if(!rs.next()){
System.out.println("============================4");
throw new BadLoginException();
}
}catch(SQLException e){
e.printStackTrace();
}
}
}
import MyException.BadLoginException;
public class LoginDAO {
private Connection con=null;
// private ResultSet rs=null;
public LoginDAO() {
getConnection();
} private Connection getConnection(){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
System.out.println("====================>");
con=DriverManager.getConnection("jdbc:odbc:notepad","","");
System.out.println("======================>>>");
}catch(Exception e){
System.out.println("==================================>>>>>>>>>>>");
e.printStackTrace();
}
return con;
} public void unLogin(String userName,String passWord)throws BadLoginException{
try{
System.out.println("=============================1");
PreparedStatement pstmt = con.prepareStatement(
"select * from login where userNmae=? and passWord=?");
pstmt.setString(1,userName);
pstmt.setString(2,passWord);
System.out.println("==============================2"+userName+"::::::"+passWord);
ResultSet rs=pstmt.executeQuery();
System.out.println("==============================3");
if(!rs.next()){
System.out.println("============================4");
throw new BadLoginException();
}
}catch(SQLException e){
e.printStackTrace();
}
}
}
解决方案 »
- 求助--刷新界面保留当前状态
- 新手请教，自己制作的jsp+mysql留言板的添加留言页面老是出错
- 怎样配置让tomcat4.1开启两个服务进程或两个端口来对应两个程序
- 关于Hibernate的问题，请各位帮忙看看！！！！
- 发送邮件出错，已经通过认证，请各位大哥指点
- 问题求解：jdbc连接oracle数据库，连接不释放，导致资源占用逐渐增加，不知原因何在
- 那里错了。。。。。
- jsp文件中调用一个第三方的jar文件，此jar包中又用了jni调用dll。但在tomcat下运行时，有时候弹出对话框来报错有关java.exe的错误，什么r
- 如何将int转化为char？
- 一个诡异的问题
- 乱谈Java版本号
- 这样做的目的是什么？
-----------------------------------------------------------------------
package action;import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionForm;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.ActionForward;
import form.LoginForm;
import dao.LoginDAO;
import org.apache.struts.action.ActionErrors;
import org.apache.struts.action.ActionError;
import MyException.BadLoginException;
import org.apache.struts.action.Action;
import javax.servlet.http.HttpSession;public class LoginAction extends Action {
public ActionForward execute(ActionMapping actionMapping,
ActionForm actionForm,
HttpServletRequest servletRequest,
HttpServletResponse servletResponse) {
LoginForm loginForm = (LoginForm) actionForm;
String name=loginForm.getUserName();
String psw=loginForm.getPassWord();
LoginDAO dao = new LoginDAO();
try{
dao.unLogin(name, psw);
}catch(BadLoginException e){
ActionErrors errors=new ActionErrors();
errors.add(ActionErrors.GLOBAL_ERROR,new ActionError("login.bad"));
this.saveErrors(servletRequest,errors);
return actionMapping.getInputForward();
}
HttpSession session= servletRequest.getSession();
session.setMaxInactiveInterval(1000*60*20);
session.setAttribute("userName",name);
return actionMapping.findForward("success");
}
}
"select * from login where userNmae=? and passWord=?");//username 笔误？
pstmt.setString(1,userName);
pstmt.setString(2,passWord);
------------------------------------------------------------------------------------
type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception javax.servlet.ServletException: No getter method for property add of bean org.apache.struts.taglib.html.BEAN
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:846)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:779)
org.apache.jsp.reg_jsp._jspService(reg_jsp.java:93)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069)
org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:455)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)