📄 jsp6.jsp~3~
字号:
<%@page contentType="text/html; charset=GBK"%>
<%@page import="java.sql.*"%>
<html><body>
<%
String getsno=request.getParameter("sno");
String sql = "select * from fapiao where sno= "+getsno+";";
Statement stmt=null;
PreparedStatement pstmt=null;
ResultSet rs=null;
//加载JDBC-ODBC桥驱动
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//定义JDBC URL
}catch (Exception e) {
out.println(e.getMessage());
}
try{
String url = "jdbc:odbc:s";
//得到与数据库的连接
Connection con = DriverManager.getConnection(url);
//显示UPL和连接信息
System.out.print("URL:" + url);
System.out.print("Connection:" + con);
//得到一个Statement对象
stmt = con.createStatement();
//执行SQL语句
System.out.print("SQL:" + sql);
ResultSet p = stmt.executeQuery(sql);
%>
<table width=600 border="2" cellpadding="2" cellspacing="3" bgcolor=#6681D9 align="center"><tr bgcolor=#6681D9 ><td height=20 colspan=5><div align=center><font SIZE="20" color="red">发票</font></td></tr><tr bgcolor=#D9E0F9 ><td align=center><font color="#309aff">学号</font></td><td align=center><font color="#309aff">教材号</font></td></tr>
<%
while(p.next())
{
out.print("<td align=center> "+p.getString("sno")+"</td>");
out.print("<td align=center> "+p.getString("bnum")+"</td></tr>");
}
}catch (Exception e) {}
%><a href="jsp2.jsp">返回主页</a><br>
<a href="###" onclick=document.execCommand("print")>打印</a><br>
</html></body>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -