zccheck.jsp~2~

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

JSP~2~
43
字号
<%@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()) { }            } catch (Exception e) {}        //加载JDBC-ODBC桥驱动%><FORM Action="zckcheck.jsp" method="POST" name="myform">请输入学号<input type="text" name="sno" style="height:18px;width:100px">&nbsp;&nbsp;请输入要申请的教材号<input type="text" name="bnum" style="height:18px;width:100px">&nbsp;&nbsp;请输入要申请的教材数量<input type="text" name="booknum" style="height:18px;width:100px">&nbsp;&nbsp;<br><br><br><br><br><input type=submit name="submit" value="申请教材" onclick="mycheck()"></FORM></center></HTML></BODY>

⌨️ 快捷键说明

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