package com.servlet;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
//import com.service.StudentService;
public class StudentSer extends HttpServlet {
private static final long serialVersionUID = 1L;
private static String driverName = "oracle.jdbc.driver.OracleDriver";
private static String conURL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static String userId = "system";
private static String password = "Oracle11g";
private static Connection connection;
public static Connection openConnection() {
// Loading the driver
try {
Class.forName(driverName);
connection = DriverManager.getConnection(conURL, userId, password);
return connection;
} catch (Exception e) {
return null;
}
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html");
PrintWriter out = response.getWriter();
String id = request.getParameter("id");
PreparedStatement statement = null;
String query=null;
if (id != null) {
query = "select * from student where id=" + id;
} else {
query = "select * from student ";
}
System.out.println(query);
try {
connection = StudentSer.openConnection();
statement = connection.prepareStatement(query);
ResultSet rs = statement.executeQuery();
ResultSetMetaData rsmd = rs.getMetaData();
int colcount = rsmd.getColumnCount();
out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
out.println("<HTML>");
out.println(" <HEAD><TITLE>A Servlet</TITLE></HEAD>");
out.println(" <BODY>");
out.println("<table border='1'>");
out.println("<tr>");
for (int i = 1; i <= colcount; i++) {
out.println("<th>" + rsmd.getColumnLabel(i) + "</th>");
}
out.println("</tr>");
while(rs.next()){
out.println("<tr>");
out.println("<td>");
out.println(rs.getString(1));
out.println("</td>");
out.println("<td>");
out.println(rs.getString(2));
out.println("</td>");
out.println("<td>");
out.println(rs.getString(3));
out.println("</td>");
out.println("<td>");
out.println(rs.getString(4));
out.println("</td>");
out.println("</tr>");
}
out.println("</table>");
out.println(" </BODY>");
out.println("</HTML>");
rs.close();
statement.close();
connection.close();
} catch (Exception e) {
System.out.println(e);
}
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doGet(request, response);
}
}
java filter 执行过程例子
需积分: 9 125 浏览量
2013-02-18
14:58:40
上传
评论
收藏 1.78MB ZIP 举报
FilterDemo.zip （25个子文件） 
FilterDemo .settings 
org.eclipse.wst.jsdt.ui.superType.name 6B org.eclipse.wst.common.project.facet.core.xml 252B org.eclipse.wst.common.component 468B org.eclipse.wst.jsdt.ui.superType.container 49B .jsdtscope 500B org.eclipse.jdt.core.prefs 395B src com filter FilterB.java 1KB FilterA.java 1KB FilterC.java 1KB servlet StudentSer.java 3KB entity Student.java 587B util UtilServlet.java 1003B .project 2KB WebRoot META-INF MANIFEST.MF 36B WEB-INF web.xml 1KB classes com filter FilterA.class 2KB FilterB.class 2KB FilterC.class 2KB servlet StudentSer.class 4KB entity Student.class 1KB util UtilServlet.class 1KB lib 
ojdbc14_g.jar 1.84MB index.jsp 1KB .mymetadata 303B .classpath 529B .myeclipse 资源评论
陈勇士
- 粉丝: 75
- 资源: 82
