smsdzbase.java

JAVA邮件系统

     /*
 *
 */

import java.io.*;
import java.text.*;
import java.sql.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;

/**
  *
 * @author Chen Xin Wu
 */

public class SmsDZBase extends HttpServlet {


    public void doGet(HttpServletRequest request,
                      HttpServletResponse response)
        throws IOException, ServletException
    {

	}
    public void doPost(HttpServletRequest request,
                      HttpServletResponse response)
        throws IOException, ServletException
    {
		doGet(request,response);
	}

  public String getUserName(String sMobile,String sPassword)
  {
      String sUserName=null;
      if ((sMobile!=null)&&(sPassword!=null))
      {
    	  DBOperater DB = new DBOperater("smsuser");
  		  String sSql="SELECT username FROM "+CommonMethods.sTableName +" WHERE mobile = '"+sMobile.trim ()+"' and password='"+sPassword.trim ()+"'";
	  	  ResultSet rs = DB.executeQuery(sSql);
		    try
		    {
			    if(rs.next()){
				      sUserName = rs.getString(1);
          }
	  	}catch(Exception ex){
		  }
      DB.close();
      }
      return sUserName;
    }
}