java 数据库连接不上_真心求助用java连接数据库时为什么总是连接不上

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

(2)这是我的servlet验证模块

package com.members_management_syste***ogintest; import java.io.*;

import javax.servlet.http.*;

import java.sql.*;

public class LoginTest extends HttpServlet{ public void doGet(HttpServletRequest req,HttpServletResponse res){

String user=req.getParameter("user");

String ps=req.getParameter("password");

Connection conn=null;

Statement st=null;

ResultSet rs=null;

try{

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

conn=DriverManager.getConnection("jdbc:sqlserver://LDHCR4Q9NOOXG52:1433;DatabaseName=Manage","sa","这里是我的数据库密码(没问题的)");

st=conn.createStatement();

String sql="select userPass top 1 from users where userName=user";

rs=st.executeQuery(sql);

while(rs.next()){

if(rs.getString(1).equals(ps)){

HttpSession hs=req.getSession(true);

hs.setMaxInactiveInterval(20);

hs.setAttribute("pass","OK");

res.sendRedirect("LoginWelcome?uname="+user+"&upass="+ps);

}else {

res.sendRedirect("login");

}

}

}catch(Exception e){

e.printStackTrace();

}finally{

try{

if(rs!=null){

rs.close();

}

if(st!=null){

st.close();

}

if(conn!=null){

conn.close();

}

}catch(SQLException e){

e.printStackTrace();

} }

}

public void doPost(HttpServletRequest req,HttpServletResponse res){

doGet(req,res);

}

}