index.jsp的部分代码
<td colspan="121" width="" height="" bgcolor="">
<form name="search_form" action="/wohenni/Search" method="post">教学资源视频查询: <br>
请输入关键字:<input type="text" name="keyword" size="16" value="请输入关键字"
onmouseover="this.focus()" onfocus="this.select()"><br>
请选择查询范围:<select name="way">
<option value="1">视频名称</option>
<option value="2">出版时间</option>
<option value="3">制作单位</option>
<option value="4">出版社</option>>
</select> <input type="button" value="查询!" onclick="search_sub()"><br>
<script language="javascript">
function search_sub()
{
if(document.search_form.keyword.value==="")
{
window.alert("请输入关键字!");
document.search_form.keyword.focus();
return ;
}
document.search_form.submit();
}
</script></form>
。。。。。。。。。。。。
package dao;
import java.sql.*;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class DBConnection {
private final String url="jdbc:mysql://localhost:3306/luxiang";
private final String userName="root";
private final String password="pikaqiu";
private java.sql.Connection con=null;
static{
try{
Class.forName("com.mysql.jdbc.Driver");
}catch(ClassNotFoundException ex){
System.out.println("数据库加载失败");
}
}
public boolean creatConnection() {
try{
con=(java.sql.Connection)DriverManager.getConnection(url, userName, password);
((java.sql.Connection) con).setAutoCommit(true);
}catch(SQLException e){
}
return true;
}
public ResultSet executeQuery(String clause){
ResultSet rs=null;
try{
if(con==null){
creatConnection();
}
Statement stmt=((java.sql.Connection) con).createStatement();
try{
rs=stmt.executeQuery(clause);
}catch(SQLException e){
}
}catch(SQLException e){
}
return rs;
}
}
。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。
package servlet;
import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.sql.*;
import dao.DBConnection;
/**
*
* @author Lenovo
*/
public class Search extends HttpServlet {
public Search() {
super();
// TODO Auto-generated constructor stub
}
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setHeader("Pragma","No-cache");