servlet连接mysql

Question

web.xml里的内容如下，连接mysql的jar包在classpath中也添加过了
<?xml version="1.0" encoding="ISO-8859-1"?><web-app xmlns="http://java.sun.com/xml/ns/javaee"
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
   xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"
   version="2.5"> 

      <servlet>
      <servlet-name>testconn</servlet-name>
      <servlet-class>MyConnection</servlet-class> 

<init-param>
<param-name>driverClass</param-name>
<param-value>com.jdbc.mysql.Driver</param-value>
</init-param>

<init-param>
<param-name>url</param-name>
<param-value>jdbc:mysql://localhost:3306/mydata</param-value>
</init-param>

<init-param>
<param-name>user</param-name>
<param-value>root</param-value>
</init-param>

<init-param>
<param-name>password</param-name>
<param-value>112358</param-value>
</init-param>

</servlet>
  
<servlet-mapping>  
<servlet-name>testconn</servlet-name>
<url-pattern>/testdb </url-pattern>
</servlet-mapping>
    
 </web-app>servlet的代码如下
import java.sql.Statement;import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;public class MyConnection extends HttpServlet
{ public void service(HttpServletRequest request, HttpServletResponse response)throws IOException,ServletException
{
PrintWriter out = response.getWriter();

out.write("test MyConnection1 zed\n");
out.write("test Servlet1");
Connection conn = null;

try{

out.write("try");
Class.forName("com.jdbc.mysql.Driver");//自己做了下测试好像是到这里就抛出异常了。
out.write("forName");
conn = DriverManager.getConnection("jdbc:mysql://localhost/mydata" , "zed" , "112358");
out.write("conn");
if(conn != null)
out.write("success");
else
out.write("failure");
Statement stat = conn.createStatement();
ResultSet rs = stat.executeQuery("select * from dept");
while(rs.next())
{
out.write(rs.getString(1));
}
}
catch(Exception e)
{
out.write("Exception");
e.printStackTrace();
}
}
}到底哪里有问题啊？怎么改 求助！

Answer 1

哦 补充一下 tomcat6.0  mysql 5.1 的版本，不用servlet连，直接用java连都没问题的

Answer 2

楼主问题已经解决，，我发现你是包的导入问题 ，，我使用的是myeclipse 7.0 mysql 5.0 
具体请 看图片和代码 
 PrintWriter out = response.getWriter();
        
        out.write("test MyConnection1 zed\n");
        out.write("test Servlet1");
        Connection conn = null;
        
        try{
            
            out.write("try");
            Class.forName("com.mysql.jdbc.Driver"); 
            out.write("forName");
            conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/demo" , "root" , "19871121");
            out.write("conn");
            if(conn != null)
                out.write("success/n");
            else
                out.write("failure/n");
            java.sql.Statement stat = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
            ResultSet rs = stat.executeQuery("select * from user");
            while(rs.next())
            {
                out.write(rs.getString(1));
            }
        }
        catch(Exception e)
        {
            out.write("Exception");
            e.printStackTrace();
        }
结果test MyConnection1 zed test Servlet1tryforNameconnsuccess/njiangyanpengtaowangbeixiaoqiangzhaoqiang注意URL要加端口