本帖最后由 360fans_ZeHHzA 于 2020-5-15 10:56 编辑
package com.jsp.servlet;
import java.io.IOException;
import java.io.InputStream;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;
import javax.servlet.ServletContext;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class ContextServlet extends HttpServlet {
/**
*
*/
private static final long serialVersionUID = 1L;
public ContextServlet() {
super();
}
public void destroy() {
super.destroy(); // Just puts destroy string in log
// Put your code here
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doPost(request, response);
response.setContentType(text/html);
PrintWriter out = response.getWriter();
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.print( This is );
out.print(this.getClass());
out.println(, using the GET method);
out.println( </BODY>);
out.println(</HTML>);
out.flush();
out.close();
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType(text/html);
response.setCharacterEncoding(utf-8);
PrintWriter out = response.getWriter();
ServletContext context=this.getServletContext();//获取ServletContext对象
//获取资源流,先获得资源真实路径,再使用InputStream创建个输入流
InputStream stream=context.getResourceAsStream(/WEB-INF/jdbc.properties);
Properties properties=new Properties();
properties.load(stream);
String dbName=properties.getProperty(dbName);
String dbUserName=properties.getProperty(dbUserName);
String dbPassWord=properties.getProperty(dbPassWord);
String url=properties.getProperty(url);
url=url+dbName+?user=+dbUserName+&password=+dbPassWord;
System.out.print(url);
try {
Class.forName(com.mysql.jdbc.Driver);
Connection conn=DriverManager.getConnection(url);
Statement stat=conn.createStatement();
String sql=select * from student;
ResultSet rs=stat.executeQuery(sql);
out.print(<table border=1);
out.print(<tr><td colspan=4></td></tr>);
out.print(<tr><td>学号</td><td>姓名</td><td>出生日期</td><td>所在班级</td><td>年龄</td></tr>);
while (rs.next()) {
out.print(<tr style='text-align:center'>);
out.print(<td>+rs.getString(1)+</td>);
out.print(<td>+rs.getString(2)+</td>);
out.print(<td>+rs.getString(3)+</td>);
out.print(<td>+rs.getString(4)+</td>);
out.print(<td>+rs.getString(5)+</td>);
out.print(</tr>);
}
out.print(</table>);
} catch (ClassNotFoundException e) {
// TODO: handle exception
e.printStackTrace();
}catch (SQLException e) {
// TODO: handle exception
e.printStackTrace();
}
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.print( This is );
out.print(this.getClass());
out.println(, using the POST method);
out.println( </BODY>);
out.println(</HTML>);
out.flush();
out.close();
}
public void init() throws ServletException {
// Put your code here
}
}
|
|
|
|
评论
直达楼层