⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 query.jsp

📁 论文提交系统
💻 JSP
字号:
🔍 
<%@ page contentType="text/html;charset=gb2312" %>
<html>
<title>查询数据库</title>
</head>
<body>
<!-- 设置脚本语言为java,引用java.sql包 -->
<%@ page language="java" import="java.sql.*" %>
<%
String title=request.getParameter("title");
String authorname=request.getParameter("authorname");
String teachername=request.getParameter("teachername");
String major=request.getParameter("major");
String keyword=request.getParameter("keyword");
String mysql;
%>
<%
    Connection con = null;

    try {
      // 登记JDBC驱动程序
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      //连接数据库
      con = DriverManager.getConnection("jdbc:odbc:bookdbf","", "");
      //创建语句对象
      Statement statement = con.createStatement();
      //执行SQL语句

String sql="";
String sqlWhere="";	 

sql="select * from bookitem ";
  if(title.length()>0)
    sqlWhere+="and a_title like '%" + title + "%'";
  if(authorname.length()>0)
    sqlWhere+="and a_authorname like '%" + authorname + "%'";

  if(teachername.length()>0)
    sqlWhere+="and a_teachername like '%" + teachername + "%'";

  if(major.length()>0)
    sqlWhere+="and a_major like '%" + major + "%'";

  if(keyword.length()>0)
    sqlWhere+="and a_keyword like '%" + keyword + "%'";  

  if(sqlWhere.length()>0)
    sql+=" where " + sqlWhere.substring(4,sqlWhere.length());
//  if(sql=="select * from bookitem")
 //  {alert("查询不能为空！");
//    return false;}
//          mysql="select * from bookitem where a_title like '"+title+"' and a_authorname like '"+authorname+"' and //a_teachername like '"+teachername+"' and a_major like '"+major+"' and a_keyword like '"+keyword+"' ";       
	  //将Unicode编码的String类型数据转化为“ISO-8859-1”编码
          byte[] temp=sql.getBytes("ISO-8859-1");
          String mysql_str=new String(temp);
out.println(mysql_str);
       	  ResultSet rs = statement.executeQuery(mysql_str);
      //取得结果，输出到屏幕
      %>
      <!-- 以HTML表格形式输出结果-->
      <table border="1">
      <tr>
      <th>论文题目</th><th>作者姓名</th><th>指导教师</th><th>专业</th><th>摘要</th>
      <th>关键词</th><th>word文档</th>
      
      <%
      while ( rs.next() ) {
        out.println("<tr>\n<td>" + rs.getString("a_title") + "</td>");
        out.println("<td>" + rs.getString("a_authorname") + "</td>");
        out.println("<td>" + rs.getString("a_teachername") + "</td>");
        out.println("<td>" + rs.getString("a_major") + "</td>");
	out.println("<td>" + rs.getString("a_ps") + "</td>");
        out.println("<td>" + rs.getString("a_keyword") + "</td>");
        
	out.println("<td>" + rs.getString("a_wordfile") + "</td>\n</tr>");
      }
      //关闭结果集<a href="index.html">下载</a><br>
      rs.close();
    }
    catch (Exception e) {
      out.println(e.getMessage());
    }
   //关闭数据库连接
   con.close();
 %>
<a href="first.jsp" ><font size=5 color="blue">返回首页</font></a><br>
</body>
</html>

⌨️ 快捷键说明

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