zccheck.jsp~6~

来自「JAVA实验图形 =各种 的 JAVA简单代码 出初学者必备!!!!!!!!!」· JSP~6~ 代码 · 共 41 行

JSP~6~
41
字号
<%@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>"); }            } catch (Exception e) {}        //加载JDBC-ODBC桥驱动%><FORM Action="zccheck.jsp" method="POST" name="myform">请输入帐号<input type="text" name="name" style="height:18px;width:100px">&nbsp;&nbsp;<br><br><br><br><br><input type=submit name="submit" value="查看帐号是否可用" ></FORM></center></HTML></BODY>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?