checkservlet.java

来自「采用web2.0技术,采用动态标签,sql语句全部存储在数据库里面.开发速度快.」· Java 代码 · 共 90 行

package com.sztheater.biz.register;

import com.sztheater.framework.util.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.jsp.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;


public class CheckServlet extends HttpServlet {
	
	ServletConfig config = null;
	
	
	public void init(ServletConfig config) throws ServletException{
		
		   super.init(config);
		}
	public void service(HttpServletRequest request,HttpServletResponse response) 
						throws ServletException,IOException{
							
			String username = "";	
			int iSuccFlag = 0;
			int iExistsNum =0;
			String strMsg = "";
			String strSQL = "";
			ResultSet  rs  = null;
			Statement  st  = null;
		  HttpSession _httpSession = null;			
		  username = 	request.getParameter("username");
		  _httpSession = request.getSession();
		  
		  ValueObject sendPack = new ValueObject();
			try{
			    Connection conn      = null;
			    try{
				conn        = DbFunc.getConnection(false);
			    }catch(Exception e){
				if(conn!=null) DbFunc.free(conn,iSuccFlag);
				conn = null;
				iSuccFlag = -90102;
				strMsg    = "服务取数据库连接异常"+e.getMessage();
			    sendPack.setErrMsg(iSuccFlag,strMsg);
			   	_httpSession.setAttribute("ERR_MSG",sendPack.getMessage());
		       }
			    //取得执行数据库操作Statement
				st   = conn.createStatement();
				strSQL  = "select count(*) as num \n"
					+ "from T_NetCustomer \n"
					+ "where LoginName = "+username+"";
			     rs   = st.executeQuery( strSQL);
				if (rs!=null && rs.next()){
					iExistsNum = rs.getInt("num");
				}
				rs.close();
				rs = null;
				if(iExistsNum<1){
					iSuccFlag = -90010106;
					strMsg = "用户名密码错误";
					 sendPack.setErrMsg(iSuccFlag,strMsg);
				}
			//	return iExistsNum;
				
			} catch(Exception e){
				
		    iSuccFlag = 20102005;
			strMsg = e.getMessage();
			System.out.println(strMsg);
			if(sendPack!=null) sendPack.addTrace(strMsg);
			strMsg = "失败！";
			System.out.println(strMsg +"\n" + e.getMessage() + "\n" + strSQL);
		    sendPack.setErrMsg(iSuccFlag,strMsg);
		}finally{
			try{
				if(rs!=null) rs.close();
			}catch(Exception e1){
			}
			try{
				if(st!=null) st.close();
			}catch(Exception e1){
			}
			rs= null;
			st= null;
		}	
		  
						}				
	
	}