checklogin.jsp.bak

学生管理系统 对学生成绩的操作

<%@ page contentType="text/html; charset=GBK" import="java.sql.*" %>
<%
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=stuManager";
String userid="LIN/breaze",pwd="123456",sql = "";
try{
  Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
  Connection conn = DriverManager.getConnection(url,userid,pwd);
  sql = "select * from users where userId='" + request.getParameter("userID") + "' and password='" + request.getParameter("pwd") + "'";
  Statement stmt = conn.createStatement();
  ResultSet rs = stmt.executeQuery(sql);
  if(rs.next())
  {
    session.setAttribute("userID",request.getParameter("userID"));
    response.sendRedirect("memCenter.jsp");
  }
  else
  {
%>
<script language="javascript">
alert("用户名或密码错误");
window.history.go(-1);
</script>
<%
  }
}catch(Exception e)
{
  System.out.println(e.getMessage());
}






%>