checklogin.jsp

jsp做的一个个人网站

<%@ page contentType="text/html; Charset=gb2312"  import="java.sql.*" errorPage="" %>
<% request.setCharacterEncoding("gb2312");
String username=request.getParameter("gly").trim();
String password=request.getParameter("pwd").trim();
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:test","sa","sa");
String message="select * from gly where name='"+username+"'and password='"+password+"'";
Statement sql=con.createStatement();
ResultSet rs=sql.executeQuery(message);
if(rs.next()){
session.setAttribute("flag","1");
session.setAttribute("customer",username);

%>
<%String ab=(String)session.getAttribute("customer");
  
   %>
 <p>登陆成功,欢迎你<% out.print(ab);%>！<br><a href="chakan1.jsp?id=<%=rs.getString(1)%>">修改您的密码</a></p>
 <p><a href="index.jsp">返回</a><br>
   
   <% }
else {
  out.print("<script>alert('您的密码有误,请核对您的密码！');location.href='index.jsp';</script>");
      }

 con.close();

 
 %>
 </p>