用web+SQLserver+jsp編寫登錄界面。要求有驗證

<%@ page language="java" import="java.util.*,java.sql.*" pageEncoding="utf-8"%>

<html>

<head>

<title>人事管理系統登錄界面</title>

Connection conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=J2EE", "sa", "123456");

PreparedStatement pstmt = conn.prepareStatement();

ResultSet rs = pstmt.executeQuery(sql);

if(career=="管理員"&&rs!=null)

request.sendRedirect("management.jsp");

else if(career=="普通用戶"&&rs!=null)

request.sendRedirect("common.jsp");

else

{

PrintWriter out = response.getWriter();

out.write("<script>alert('登陸失敗！')</script>");

request.sendRedirect("manager.jsp");

}