📄 6.jsp~4~
字号:
<%@page language="java" contentType="text/html; charset=GBK"%><%@page import="java.sql.*"%><%@page import="java.io.*"%><%request.setCharacterEncoding("gb2312");%><html><head><title>新闻中心搜索结果</title><link href="css2.css" rel="stylesheet" type="text/css" /></head><body><div id="container"> <div id="Header"> </div> <%String getsousuo;String id; getsousuo= new String (request.getParameter("sousuo").getBytes("iso-8859-1"),"gb2312"); getsousuo='%'+getsousuo+'%'; String sql = " select * from xinwen where xinwenname like '"+getsousuo+"'"; 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); ResultSetMetaData meta = p.getMetaData(); %><table width=1200 border="2" cellpadding="1" cellspacing="3" bgcolor=#6681D9 ><tr bgcolor=#6681D9 ><td height=20 colspan=9><div ><center>后台管理</center></td></tr><tr bgcolor=#D9E0F9><td align=center><font color="#309aff">教材号</font></td><td align=center><font color="#309aff">教材名</font></td><td align=center><font color="#309aff">教材单价</font></td><td align=center><font color="#309aff">教材出版社</font></td><td align=center><font color="#309aff">教材余额</font></td><td align=center><font color="#309aff">教材图片</font></td><td align=center><font color="#309aff">教材说明</font></td><td ><font color="#309aff">修改</font></td><td><font color="#309aff">删除</font></td></tr> <% while(p.next()) { id=p.getString("id"); out.print("<td > "+id+"</td>"); out.print("<td > "+p.getString("xinwenname")+"</td>"); out.print("<td> "+p.getString("xinwentype")+"</td>"); out.print("<td> "+p.getString("xinwenshuoming")+"</td>");out.print("<td><a href='xwxiugai.jsp?id="+id+"'>修 改</a> </td>");out.print("<td> <a href='xwshanchu.jsp?id="+id+"'>删 除</a> </td></tr>"); } } catch (Exception e) {}%></table><a href="xw.jsp">返回新闻中心主页</a></body></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -