javascript的代码

来源：互联网发布：linux怎么配置ip地址编辑：程序博客网时间：2024/05/12 12:14

<%@ page contentType="text/html; charset=GB2312" import="java.sql.* " %><%@ page import="java.io.* " %> <%! String CheckLogin(String Login1, String Password1) throws Exception {Connection con = null; Statement stmt = null;ResultSet rs = null;String result = null; String Login=Login1.trim(); String Password=Password1.trim();try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");con = DriverManager.getConnection("jdbc:odbc:grade");stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);String strSQL = "SELECT * FROM Login " +"WHERE XM= '" + Login + "'";rs = stmt.executeQuery(strSQL);//执行SQL语句,进行帐号查询if(!rs.next()) //检查游标是否指到最后一条记录{ //若指向最后一条记录则表示没有记录result = "无此帐号";}else if(!rs.getString("PW").equals(Password)) //判断密码是否正确{ result = "密码错误";}else //通过检查表示帐号与密码均正确成功登入{result = "成功登入";}}catch(Exception ex){throw ex;}finally{rs.close(); stmt.close(); con.close(); }return result; } %> <% String UserNm = request.getParameter("UserNm");//取得表单输入的帐号 String UserPasswd = request.getParameter("UserPasswd");//取得表单输入的密码 //判断使用者帐号与密码所取得值是否为null, 是则将网页导向LogFrm.htm if(UserNm == null || UserPasswd == null)response.sendRedirect("LogFrm.htm"); String strCheckLogin = CheckLogin(UserNm, UserPasswd);//进行帐号与密码的检查 if (strCheckLogin.equals("成功登入")) //判断是否成功登入 {session.setAttribute("UserNm",UserNm); //将登入帐号储存进session中session.setAttribute("UserPasswd",UserPasswd);//将帐号密码储存进session中response.sendRedirect("LoginSuccess.jsp");//将显示网页导向LoginSuccess.jsp网页 } %><HTML><HEAD><TITLE>用户登录</TITLE></HEAD><BODY ><CENTER><FONT SIZE = 5 COLOR = blue>使用者登录</FONT></CENTER><HR><Center> <%= strCheckLogin %> <P></P> <A href = "LogFrm.htm">请重新登录</A></Center></BODY></HTML><%@ page contentType="text/html; charset=GB2312" import="java.sql.* " %><%@ page import="java.io.* " %> <%! String CheckLogin(String Login1, String Password1) throws Exception {Connection con = null; Statement stmt = null;ResultSet rs = null;String result = null; String Login=Login1.trim(); String Password=Password1.trim();try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");con = DriverManager.getConnection("jdbc:odbc:grade");stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);String strSQL = "SELECT * FROM Login " +"WHERE XM= '" + Login + "'";rs = stmt.executeQuery(strSQL);//执行SQL语句,进行帐号查询if(!rs.next()) //检查游标是否指到最后一条记录{ //若指向最后一条记录则表示没有记录result = "无此帐号";}else if(!rs.getString("PW").equals(Password)) //判断密码是否正确{ result = "密码错误";}else //通过检查表示帐<%@ page contentType="text/html; charset=GB2312" import="java.sql.* " %><%@ page import="java.io.* " %> <%! String CheckLogin(String Login1, String Password1) throws Exception {Connection con = null; Statement stmt = null;ResultSet rs = null;String result = null; String Login=Login1.trim(); String Password=Password1.trim();try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");con = DriverManager.getConnection("jdbc:odbc:grade");stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);String strSQL = "SELECT * FROM Login " +"WHERE XM= '" + Login + "'";rs = stmt.executeQuery(strSQL);//执行SQL语句,进行帐号查询if(!rs.next()) //检查游标是否指到最后一条记录{ //若指向最后一条记录则表示没有记录result = "无此帐号";}else if(!rs.getString("PW").equals(Password)) //判断密码是否正确{ result = "密码错误";}else //通过检查表示帐<%@ page contentType="text/html; charset=GB2312" import="java.sql.* " %><%@ page import="java.io.* " %> <%! String CheckLogin(String Login1, String Password1) throws Exception {Connection con = null; Statement stmt = null;ResultSet rs = null;String result = null; String Login=Login1.trim(); String Password=Password1.trim();try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");con = DriverManager.getConnection("jdbc:odbc:grade");stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);String strSQL = "SELECT * FROM Login " +"WHERE XM= '" + Login + "'";rs = stmt.executeQuery(strSQL);//执行SQL语句,进行帐号查询if(!rs.next()) //检查游标是否指到最后一条记录{ //若指向最后一条记录则表示没有记录result = "无此帐号";}else if(!rs.getString("PW").equals(Password)) //判断密码是否正确{ result = "密码错误";}else //通过检查表示帐