📄 zccheck.jsp~7~
字号:
<%@page contentType="text/html; charset=GBK"%><%@page import="java.sql.*"%><%request.setCharacterEncoding("gb2312");%><link href="2.css" rel="stylesheet" type="text/css" /><HTML><BODY><center><div id="container"><div id="Header"></div> <html><body><% String getname = request.getParameter("name");%><% Statement stmt=null; PreparedStatement pstmt=null;String str = "select * from adm where name='"+getname+"'"; //加载JDBC-ODBC桥驱动 try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //定义JDBC URL }catch (Exception e) { out.println(e.getMessage()); } try{ System.out.print("SQL:" + str); String url = "jdbc:odbc:s"; //得到与数据库的连接 Connection con = DriverManager.getConnection(url); stmt = con.createStatement(); ResultSet g = stmt.executeQuery(str); while(g.next()) {out.print("<script>type='text/JavaScript'>alert('登陆失败,用户名或密码错');</script>"); } out.print("<script>type='text/JavaScript'>alert('登陆失败,用户名或密码错');</script>"); } catch (Exception e) {} //加载JDBC-ODBC桥驱动%><FORM Action="zccheck.jsp" method="POST" name="myform">请输入帐号<input type="text" name="name" style="height:18px;width:100px"> <br><br><br><br><br><input type=submit name="submit" value="查看帐号是否可用" ></FORM></center></HTML></BODY>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -