java端代码如下：

package com.xxxx.xxxx.servlet;

import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.sqlException;

import javax.naming.Context;
import javax.naming.InitialContext;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.sql.DataSource;

public class oaLoginLimitedServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
	private static Connection conn=null;
	private static PreparedStatement pstmt=null;
	
	  public oaLoginLimitedServlet() {
	        super();
	    }

	  public void destroy() {
	        super.destroy(); 
	    }
	
	
	public static String getCount(String userid) 
	{
		String v_sql=".....";
		String v_count="";
		
		try {
			pstmt = conn.prepareStatement(v_sql);
			pstmt.setString(1,userid);
			ResultSet rs = pstmt.executeQuery();
			while(rs.next()){
				v_count = rs.getString(1);
			}
		} catch (sqlException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			try {
				pstmt.close();
				conn.close();
			} catch (sqlException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		return v_count;
	}
	
	 public static Connection getConnection(){      
	        Context ctx = null;    
	        try {    
	            ctx = new InitialContext();    
	            DataSource ds = (DataSource)ctx.lookup("jndiname");    
	            conn = ds.getConnection();    
	        } catch (Exception e) {    
	            e.printStackTrace();    
	        }              
	        return conn;                
	    }   
	 
	    public void doPost(HttpServletRequest request,HttpServletResponse response)
	            throws ServletException,IOException {
	    	String v_userid=request.getParameter("userid");
	    	System.out.println(v_userid);
	    	getConnection();
	    	String v_count=getCount(v_userid);
	    	response.setCharacterEncoding("UTF-8"); 
	    	response.getWriter().write(v_count);   	
	      response.flushBuffer();
	    }
	    
	    public void doGet(HttpServletRequest request,IOException {
	    	doPost(request,response);
	    }


}

如果要前端能够访问到该servlet，需要将该servlet注册到web.xml文件中。需要在web.xml文件中添加以下内容

  <servlet>
      <servlet-name>oaLoginLimitedServlet</servlet-name>
      <servlet-class>com.xxxx.xxxx.servlet.oaLoginLimitedServlet</servlet-class>
  </servlet>
  <servlet-mapping>
      <servlet-name>oaLoginLimitedServlet</servlet-name>
      <url-pattern>/oaLoginLimitedServlet</url-pattern>
  </servlet-mapping>

重启相关服务。

通过ajax就可以调用了。

var msg = $.ajax({
 type: "post",url: ....+'/oaLoginLimitedServlet?userid='+ $('#act').val(),async:false
}).responseText;