eclipes中服务器不显示,eclipse 显示数据库_eclipse中数据库里的数据不显示

问题补充：

/*

* To change this template, choose Tools | Templates

* and open the template in the editor.

*/

package cn.cslg.controller;

import java.io.IOException;

import java.sql.DriverManager;

import java.util.LinkedList;

import java.util.List;

import javax.servlet.RequestDispatcher;

import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import javax.servlet.http.HttpSession;

import com.mysql.jdbc.Connection;

import com.mysql.jdbc.ResultSet;

import com.mysql.jdbc.Statement;

import cn.cslg.model.UserInfo;

@WebServlet(name = "AddBookmarkServlet", urlPatterns = {"/AddBookmarkServlet"})

public class AddBookmarkServlet extends HttpServlet{

protected void processRequest(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

List errorMsgs=new LinkedList();

request.setAttribute("errorMsgs", errorMsgs);

String webname=new String(request.getParameter("webname").getBytes("ISO-8859-1"),"UTF-8");

String website=new String(request.getParameter("website").getBytes("ISO-8859-1"),"UTF-8");

String genre1=new String(request.getParameter("genre1").getBytes("ISO-8859-1"),"UTF-8");

String genre2=new String(request.getParameter("genre2").getBytes("ISO-8859-1"),"UTF-8");

String genre;

if(webname.equals(""))

{

errorMsgs.add("请填写网页名称");

}

if(website.equals(""))

{

errorMsgs.add("网址不能为空");

}

if(!"".equals(genre2))

{

genre=genre2;

}

else{

genre=genre1;

}

if(!errorMsgs.isEmpty())

{

RequestDispatcher view=request.getRequestDispatcher("add.jsp");

view.forward(request, response);

} else{

try{

ResultSet rs;

Class.forName("com.mysql.jdbc.Driver");

String url="jdbc:mysql://localhost:3306/bookmark";

Connection connection = (Connection) DriverManager.getConnection(url,"root","");

Statement statement=(Statement) connection.createStatement();

String userName;

HttpSession session=request.getSession();

UserInfo ui=(UserInfo)session.getAttribute("ui");

userName=ui.getUserName();

String sql2="insert into bookmark"+"(userName,webname,website,genre)"+"values("+"'"+userName+"'"+","

+"'"+webname+"'"+","+"'"+website+"'"+","+"'"+genre+"'"+")";

statement.executeUpdate(sql2);

response.sendRedirect("success.jsp");

String sql3="select * from bookmark where userName='"+userName+"'";

rs=(ResultSet) statement.executeQuery(sql3);

rs.close();

statement.close();

connection.close();

response.sendRedirect("add.jsp");

}

catch(Exception e)

{

}

}

}

@Override

protected void doGet(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

processRequest(request, response);

}

@Override

protected void doPost(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

processRequest(request, response);

}

@Override

public String getServletInfo() {

return "Short description";

}

}