📄 odbc连接.jsp
字号:
<%@page contentType = "text/html;charset=GB2312" import = "java.sql.*"%>
<%@page import = "java.util.*,java.text.*"%>
<html>
<title>取出并显示表中的信息</title>
<body>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:webdata");
Statement smt = con.createStatement();
String sql;
sql = "select bh,shrxx,shrdh,shrdz,hwjs,bzxs,yf,bjd from hy";
ResultSet rs = smt.executeQuery(sql);
out.println("取出表中的的所有信息");
%>
请点击这里</font><a href="javascript:history.back(1)"><b><font color="#FF0000">返回</font></b></a><hr>
<%
out.println("<table border = '1'>");
out.println("<tr bgcolor = 'yellow'><th>货单号</th><th>收货人姓名</th><th>收货人电话</th><th>收货人住址</th><th>货件数量</th><th>包装形式</th><th>运费</th><th>报价单</th></tr>");
while(rs.next())
out.println("<tr><td>" + rs.getString(1) + "</td><td>" + rs.getString(2) + "</td><td>" + rs.getString(3) + "</td><td>" + rs.getString(4) + "</td><td>" + rs.getString(5) + "</td><td>" + rs.getString(6) + "</td><td>" + rs.getString(7) + "</td><td>" + rs.getString(8) + "</td></tr>" );
con.close();
%>
<html>
<body>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -