<%@?page?contentType="text/html;charset=GB2312"%>
<%@?page?import="java.sql.*"%>
<html>
<head>
<title>Java?Web</title>
</head>
<body>
?????
<%
???????
???Connection?conn=null;
????try
????{
???????String?uid=request.getParameter("uid");
???????String?pwd=request.getParameter("pwd");
???????Class.forName("com.mysql.jdbc.Driver");
??????String?url="jdbc:mysql://localhost:3306/news";
???????conn=DriverManager.getConnection(url,"root","123456");
?????????????
???????Statement?st=conn.createStatement();
????????ResultSet?rs=st.executeQuery("select?*?from?tb1");
???????
??????while(rs.next())
???????{
????????String?username=rs.getString(1);
????????String?password=rs.getString(2);
???????}
???????if(username.equals(uid)?&&?password.equals(pwd))
?????????{
???????session.setAttribute("login","ok");
???????session.setMaxInactiveInterval(-1);
??????? ???response.setStatus(HttpServletResponse.SC_MOVED_PERMANENTLY);
???????response.setHeader("Location","main.jsp");?
?????????}?
???????else?
???????{
????out.println("用戶名或密碼輸入錯誤!");
????break;
???????}
????}
????catch(Exception?e)
????{
?????out.println("some?error");
??????out.println(e.toString());
????}
????finally
????{
??????conn.close();
????}
%>
</body>
</html>瀏覽器報錯如下:
網站登錄界面調用MySQL數據庫用戶名和密碼是出現錯誤,我寫的jsp代碼如下,報錯內容截圖,希望幫我看一下
UDUN
2016-05-21 14:14:01