logionaction.java~3~

这程序利用jsp实现BBS论坛系统

package bbs;

import org.apache.struts.action.*;
import javax.servlet.http.*;
import java.sql.*;

public class logionAction extends Action {
  public ActionForward execute(ActionMapping actionMapping, ActionForm actionForm, HttpServletRequest httpServletRequest, HttpServletResponse httpServletResponse) {
    /**@todo: complete the business logic here, this is just a skeleton.*/
    logionActionForm rf = (logionActionForm) actionForm;
    String username = rf.getUsername();
    String password = rf.getPassword();
    String uesrname1 = null;
    String password1 = null;
   try {
     String MySQLDriver = "org.gjt.mm.MySQL.Driver";
     String url = "jdbc:MySQL://localhost:3036/bbs";//数据库连接
     Connection conn;
     Class.forName(MySQLDriver);
     conn = DriverManager.getConnection( url,"root","521");//用户名与密码


     //DriverManager.registerDriver(new sun.jdbc.odbc.JdbcOdbcDriver());
     //Connection conn=DriverManager.getConnection("jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=..\\struts\\user.mdb","","");
     PreparedStatement stmt=conn.prepareStatement("select * from user where username=? and password=?");
     stmt.setString(1, username);
     stmt.setString(2, password);
     ResultSet rs = stmt.executeQuery();
    while (rs.next()) {
      uesrname1 = rs.getString(1);
      password1 = rs.getString(2);
    }
   }catch (Exception e) {
    }
  if(uesrname1!= null)
     return actionMapping.findForward("success");
   else
     return actionMapping.findForward("failure");
 }
 }