当前位置: 代码迷 >> Java Web开发 >> jsp连接 mysql问题
  详细解决方案

jsp连接 mysql问题

热度:344   发布时间:2005-02-22 10:53:00.0
jsp连接 mysql问题
javax.servlet.ServletException: Communication failure during handshake. Is there a server running on localhost:3306?

我得mysql已经启动为什么总提示上面的问题。问题出在哪里呢??请各位大侠帮忙。
搜索更多相关主题的帖子: mysql  jsp  

----------------解决方案--------------------------------------------------------
jsp连接Mysql数据库
<%@ page contentType="text/html;charset=gb2312"%>
<% @page import="java.sql.*"
         import="java.util.*"
         import="java.io.*"%>
<% Connection conn;
   ResultSet rs;
   String sql="SELECT * FROM test";
   Statement stmt;
   try{
   Class.forName("org.gjt.mm.mysql.Driver").newInstance();
   conn=DriverManager.getConnection("jdbc:mysql://localhost/test");
   stmt=conn.createStatement();
   rs=stmt.executeQuery(sql);
   outTable(rs,out);
  }
catch(Exception e){
        e.printStackTrace(out);
        }
finally{
      try{
         if(rs!=null)  rs.close();
         if(stmt!=null) stmt.close();
         if(conn!=null) conn.close();
         }
         catch(Exception e){}
         }
  private void outTable(ResultSet rs,PrintWriter out) throw Exception{
       out.println("<center><table border='2'>");
        ResultSetMetaData rsmd=rs.getMetaData();
        int colCount=rsmd.getColumnCount();%>
       <tr>
           <%for(int i=0;i<colCount;i++){%>
                 <th><%=rsmd.getColumnLabel(i+1)%><th>
                    <%}%>
   </tr>
     <%while(rs.next()){%>
               <tr>
               <%for(int i=0;i<colCount;i++){
                     %>
               <td><%=rs.getString(i+1)%></td>
               <%}%>
        </tr>
         <%}%>
          </table></center>
<%}
%>
----------------解决方案--------------------------------------------------------
  相关解决方案