mysql登录跳转不了_用jsp写了一个mysql连接的登录界面，运行之后总是跳到登录失败的界面，不知怎么回事，请大神指教。...

处理登陆界面的用户名和密码的代码如下：

处理登陆界面的用户名和密码的代码如下：

String name = request.getParameter("uname") ;

String password = request.getParameter("upassword") ;

boolean flag = false ;

String dbName = "test";

String tbName = "login";

String drive = "com.mysql.jdbc.Driver";

String url="jdbc:mysql://localhost/"+dbName;

String User = "root";

String Pw = "123456";

Connection con = null;

PreparedStatement pstmt = null ;

ResultSet rs = null ;

Statement st = null;

String sql = null;

try{

sql = "SELECT * FROM login WHERE username = '"+name+"' and password= '"+password+"'" ;

Class.forName("com.mysql.jdbc.Driver");

con=DriverManager.getConnection(url,User,Pw);

pstmt = con.prepareStatement(sql) ;

pstmt.setString(1,name) ;

pstmt.setString(2,password) ;

st = con.createStatement();

rs = st.executeQuery(sql) ;

// 输出每一个数据值

while(rs.next()) {

flag = true ;

}

rs.close();

st.close();

pstmt.close() ;

con.close();

}

catch (Exception e){}

%>

if(flag)

{

%>

}

else

{

%>

}

%>

展开