軟體151朱實友
login.jsp
logincheck.jsp
pageEncoding="utf-8"%>
Insert title here
request.setCharacterEncoding("UTF-8");
String username=(String)request.getParameter("username");
String password=(String)request.getParameter("password");//取出login.jsp的值
//下面是資料庫操作
String sql="select * from Table_1 where name="+"'"+username+"'";//定義一個查詢語句
ResultSet rs=db.executeQuery(sql);//運作上面的語句
if(rs.next())
{
if(password.equals(rs.getObject("password"))){
response.sendRedirect("loginsuccess.jsp");
}
else{
out.print("");
response.setHeader("refresh", "0;url=login.jsp");
}
}
else
{
out.print("");
response.setHeader("refresh", "0;url=login.jsp");
}
%>