📄 zccheck.jsp~2~
字号:
<%@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"> 请输入要申请的教材号<input type="text" name="bnum" style="height:18px;width:100px"> 请输入要申请的教材数量<input type="text" name="booknum" style="height:18px;width:100px"> <br><br><br><br><br><input type=submit name="submit" value="申请教材" onclick="mycheck()"></FORM></center></HTML></BODY>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -