import javax.servlet.*;
import javax.servlet.http.*;import java.io.*;
import java.sql.*;
//1.仔细检查连接串。
//2.确认有没有这个表
//3.如果出错了。先去后台看报错的信息。
//4.确认mysql已经启动了。
//5.把jdbc的驱动拷贝到tomcat
public class ShowRs extends HttpServlet {@Overrideprotected void doGet(HttpServletRequest request,HttpServletResponse response) throws ServletException, IOException {Connection conn = null;Statement stmt = null;ResultSet rs = null;response.setContentType("text/html");response.setCharacterEncoding("gb2312");PrintWriter out = response.getWriter();out.println("");out.println("| Content: |
");try {Class.forName("com.mysql.jdbc.Driver");conn = DriverManager.getConnection("jdbc:mysql://localhost/bbs?user=root&password=bjsxt");stmt = conn.createStatement();rs = stmt.executeQuery("select * from article"); while(rs.next()){out.println("");out.println("| " + rs.getString("cont") + " | ");out.println("
");}out.println("
");} catch (ClassNotFoundException e) {e.printStackTrace();} catch (SQLException e) {e.printStackTrace();} finally {try {if(rs != null) {rs.close();rs = null;}if(stmt != null) {stmt.close();stmt= null;}if(conn != null) {conn.close();conn = null;}} catch (SQLException e) {e.printStackTrace();}}}}
本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！
