数据库用户密码都对,请高手帮我看下哪里有错误。(附图是抛出的数据库密码错误的异常
)
<%@ page language="java" import="java.sql.*" pageEncoding="gb18030"%>
<%
String uname=request.getParameter("uname");
String upwd=request.getParameter("upwd");
String s1=request.getParameter("A");
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
String url="jdbc:oracle:thin:@localhost:1521:orcl";
String name="system";
String pwd="Sa123456";
Connection conn=DriverManager.getConnection(url,name,pwd);
System.out.println("连接成功");
Statement st=conn.createStatement();
String sql="select * from shop_user where u_name='"+uname+"'and u_password='"+upwd+"'";
ResultSet rs=st.executeQuery(sql);
if(rs.next()){
conn.close();
if(s1.equals("1")||"admin".equals(uname)&&"123".equals(upwd))
{
session.setAttribute("username",uname);
response.sendRedirect("admin/index.jsp");
}if(s1.equals("2")){
session.setAttribute("username",uname);
response.sendRedirect("index.jsp");
}}else{
System.out.println("连接失败");
response.sendRedirect("fail.jsp");
}
}catch(Exception e){
System.out.println("连接失败");
e.printStackTrace();
}
%>