jsp中连接sqlserver数据库报错

[ghh123654]

The web application [/UserSys] registered the JDBC driver [com.microsoft.sqlserver.jdbc.SQLServerDriver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.

 package com.control;

import java.io.IOException;
import java.util.ArrayList;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.model.UserBeanCl;

public class LoginClServlet extends HttpServlet {
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		String u = request.getParameter("username");
		String p = request.getParameter("passwd");
		UserBeanCl ubc = new UserBeanCl();
		if (ubc.checkUser(u, p)) {
			ArrayList al = ubc.getUsersByPage(1);
			int pageCount = ubc.getPageCount();
			request.setAttribute("result", al);
			request.setAttribute("pageCount", pageCount + "");
			// 转向 低效率
			//response.sendRedirect("wel.jsp");
			// 转发 高效率
			request.getRequestDispatcher("main.jsp").forward(request, response);

		} /*else {
			//response.sendRedirect("login.jsp");
			request.getRequestDispatcher("login.jsp")
					.forward(request, response);

		}*/
	}

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

}



//处理分页与用户的增、删、查、改
package com.control;

import java.io.IOException;
import java.io.PrintWriter;
import java.util.ArrayList;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.model.*;

public class UsersClServlet extends HttpServlet {
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		//获得标志位
		 String flag = request.getParameter("flag");
		 if (flag.equals("fengye")){
		try {
			int pageNow = Integer.parseInt(request.getParameter("pageNow"));
			UserBeanCl ubc = new UserBeanCl();
			ArrayList al = ubc.getUsersByPage(pageNow);
			int pageCount = ubc.getPageCount();
			request.setAttribute("result", al);
			request.setAttribute("pageCount", pageCount + "");
			request.setAttribute("pageNow", pageNow + "");
			request.getRequestDispatcher("wel.jsp").forward(request, response);
		} catch (Exception e) {
			e.printStackTrace();
			// TODO: handle exception
		}

	}else if(flag.equals("delUser")){
		//得到用户ID
	 String userId = request.getParameter("userId");
	 //创建 UserBeanCl
	 UserBeanCl ubc = new UserBeanCl();
	 
	 if (ubc.delUserById(userId)){
		 
		request.getRequestDispatcher("suc.jsp").forward(request, response);
		  
	 }else{
		 
		 request.getRequestDispatcher("err.jsp").forward(request, response);
	 }
	}
	 else if(flag.equals("addUser")){
			//完成添加用户
		   //得到用户输入的信息
		 String name  = request.getParameter("userName");
		 String passwd  = request.getParameter("passwd");
		 String grade  = request.getParameter("grade");
		 //创建UserBeanCl
		 UserBeanCl ubc = new UserBeanCl();
		 
		 if (ubc.addUser(name, passwd, grade)){
			 
			request.getRequestDispatcher("suc.jsp").forward(request, response);
			  
		 }else{
			 
			 request.getRequestDispatcher("err.jsp").forward(request, response);
		 }
	}

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

		this.doGet(request, response);
	}

}





package com.model;
import java.sql.*;
public class ConnDB {
 private Connection ct=null;
 public Connection  getConn(){
	 
	 try {
	    Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
		String url = "jdbc:sqlserver://localhost:1483;databaseName=myuser";
		ct = DriverManager.getConnection(url,"sa","4221");  
		 
	 }catch(Exception e){
		 e.printStackTrace();
		 
	 }
	 
	 return ct;
 }
}



package com.model;

public class UserBean {	
	private int UserId;
    private String Username;
    private String passwd;
    private int grade;
	public int getUserId() {
			return UserId;
		}
		public void setUserId(int userId) {
			UserId = userId;
		}
		public String getUsername() {
			return Username;
		}
		public void setUsername(String username) {
			Username = username;
		}
		public String getPasswd() {
			return passwd;
		}
		public void setPasswd(String passwd) {
			this.passwd = passwd;
		}
		public int getGrade() {
			return grade;
		}
		public void setGrade(int grade) {
			this.grade = grade;
		}
	

}




package com.model;
import java.util.ArrayList;
import java.sql.*;
import java.util.*;

public class UserBeanCl {
	private PreparedStatement sm = null;
	private ResultSet rs = null;
	private Connection ct = null;
	private int pageSize = 3;
	private int rowCount = 0;
	private int pageCount = 0;
	
	public boolean addUser(String name,String passwd,String grade){
		boolean b = false;
    	try {
    		//得到连接
    		ct = new ConnDB().getConn();
			sm=ct.prepareStatement("insert into iusers values('"+name+"','"+passwd+"','"+grade+"')");
			//执行
			int a=sm.executeUpdate();
			if (a==1){
				//添加成功
				b=true;
			}
			
		} catch (Exception e) {
			e.printStackTrace();
			
		}finally{
			this.close();
			
		}
    	return  b;
	}
    public boolean delUserById(String id){
    	boolean b = false;
    	try {
    		ct = new ConnDB().getConn();
			sm=ct.prepareStatement("delete from iusers where UserId='"+id+"'");
			int a=sm.executeUpdate();
			if (a==1){
				b=true;
			}
			
		} catch (Exception e) {
			e.printStackTrace();
			
		}finally{
			this.close();
			
		}
    	return  b;
    }
	public int getPageCount() {
		try {
			sm = ct.prepareStatement("select * from iusers ");
			ct = new ConnDB().getConn();
			rs = sm.executeQuery();
			if (rs.next()) {
				rowCount = rs.getInt(1);
			}

			if (rowCount % pageSize == 0) {
				pageCount = rowCount / pageSize;
			} else {
				pageCount = rowCount / pageSize + 1;

			}

		} catch (Exception e) {
               e.printStackTrace();
			// TODO: handle exception
		} finally {

			this.close();
		}

		return pageCount;
	}

	public ArrayList getUsersByPage(int pageNow) {
		ArrayList al = new ArrayList();
		try {
			sm = ct.prepareStatement("select top " + pageSize
					+ "from iusers where userId not in (select top " + pageSize
					* (pageNow - 1) + "userId from iusers )");
			rs = sm.executeQuery();
			while (rs.next()) {
				UserBean ub = new UserBean();
				ub.setUserId(rs.getInt(1));
				ub.setUsername(rs.getString(2));
				ub.setPasswd(rs.getString(3));
				ub.setGrade(rs.getInt(4));
				al.add(ub);
			}
		} catch (Exception e) {

			e.printStackTrace();
		} finally {

			this.close();
		}
		return al;
	}

	public void close() {
		try {
			if (rs != null) {
				rs.close();
				rs = null;
			}
			if (sm != null) {
				sm.close();
				sm = null;
			}
			if (ct != null) {
				ct.close();
				ct = null;
			}
		} catch (Exception e) {
			e.printStackTrace();
			// TODO: handle exception
		}
	}

	public boolean checkUser(String u, String p) {
		boolean b = false;
		try {

			ct = new ConnDB().getConn();
			sm = ct.prepareStatement("select passwd from iusers where username='"
					+ u + "'");
			rs = sm.executeQuery();
			if (rs.next()) {
				if (rs.getString(1).equals(p)) {

					b = true;

				}
			}

		} catch (Exception e) {
			e.printStackTrace();
			// TODO: handle exception
		} finally {

			this.close();

		}
		// TODO: handle exception
		return b;

	}

}



<%@ page language="java" import="java.util.*,java.sql.*,com.model.*" pageEncoding="gb2312"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>My JSP 'wel.jsp' starting page</title>
    
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<meta http-equiv="expires" content="0">    
	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
	<meta http-equiv="description" content="This is my page">
	<!--
	<link rel="stylesheet" type="text/css" href="styles.css">
	-->

  </head>
  
  <body bgcolor="pink">
  <center>
    登录成功!<%=request.getParameter("user") %><br>
  <a href="login.jsp">返回重新登录</a>
   <a href="main.jsp">返回主界面</a>
  <hr>
  <h1> 用户信息列表<h1>
   <% 
  int pageNow=1;
  //String s_pageNow=request.getParameter("pageNow");
 //if (s_pageNow!=null){
 // pageNow=Integer.parseInt(s_pageNow);

 // UserBeanCl ubc= new UserBeanCl();
 // ArrayList al = ubc.getUsersByPage(pageNow);
 ArrayList al = (ArrayList)request.getAttribute("result");
  %>
  <table border="1">
   <tr><td>用户ID</td><td>用户名</td><td>密码</td><td>级别</td><td>修改用户</td><td>删除用户</td></tr>
  
   
   <%
   for (int i =0;i<al.size();i++){
   UserBean ub =(UserBean)al.get(i);
  %>
  <tr><td><%=ub.getUserId() %> </td> <td> <%=ub.getUsername() %></td> 
  <td><%=ub.getPasswd() %></td><td><%=ub.getGrade() %></td>
 <td> <a href="updateUser.jsp?userName=<%=ub.getUsername() %>&passwd=<%=ub.getPasswd() %>&grade=<%=ub.getGrade() %>&userId=<%=ub.getUserId()%>">修改用户</a></td><td> <a href ="UserClServlet?flag=delUser&UserId=<%=ub.getUserId() %>">删除用户  </a></td> </tr>
  <% 
   }
   
    %>
   </table> 
     <%

if(pageNow!=1){
out.println("<a href =UsersClServlet?flag=fengye&pageNow="+(pageNow-1)+">上一页</a>");

}
 String s_pageCount=((String)request.getAttribute("pageCount"));
int pageCount=Integer.parseInt(s_pageCount);
for (int i=1;i<=pageCount;i++){

out.println("<a href =UsersClServlet?flag=fengye&pageNow="+i+">["+i+"]</a>");

}

if(pageNow!=pageCount){
out.println("<a href =UsersClServlet?flag=fengye&pageNow="+(pageNow+1)+">下一页</a>");

}

%>

  <center>
  </body>
</html>
     

[shoppo0505]

ConnectionString只有用户名没有密码?