《Web开发技术》课件第7章.ppt

TestMysqlConnection.java文件如下：

packageservlet.web;

importjava.io.IOException;

importjava.io.PrintWriter;

importjavax.servlet.ServletException;

importjavax.servlet.http.HttpServletRequest;

importjavax.servlet.http.HttpServletResponse;

publicclassTestMySqlConnectionextends

javax.servlet.http.HttpServletimplements

javax.servlet.Servlet{

publicTestMySqlConnection(){

super();

}

protectedvoiddoGet(HttpServletRequestrequest,

HttpServletResponseresponse)throwsServletException,

IOException{

response.setContentType(text/html;charset=gb2312);

PrintWriterout=response.getWriter();

java.sql.ConnectionConn=null;

java.lang.StringstrConn=null; try

{

Class.forName(“org.gjt.mm.mysql.Driver”).newInstance();

Conn=java.sql.DriverManager.getConnection

(“jdbc:mysql://localhost/test”,null,null);

out.println(ConnecttoMySQLsuccess!);

}

catch(java.sql.SQLExceptionexception)

{

out.println(exception.toString());

} catch(Exceptionexception)

{

out.println(exception.toString());

}

}

protectedvoiddoPost(HttpServletRequestrequest,

HttpServletResponseresponse)throwsServletException,

IOException{

}

}注意查看web.xml中是否由向导自动添加了关于该Servlet的配置项，如果没有添加，就自己手动添加。web.xml文件内容如下(只摘选关于该Servlet的配置项)：

servlet

description

/description

display-name

TestMySqlConnection/display-name

servlet-nameTestMySqlConnection/servlet-name

servlet-class servlet.web.TestMySqlConnection/servlet-class

/servlet

servlet-mapping

servlet-nameTestMySqlConnection/servlet-name

url-pattern/TestMySqlConnection/url-pattern

/servlet-mapping

运行结果界面如图7.44所示。如果驱动程序没有正确装载，显示如图7.45所示界面。如果驱动程序装载成功，MySQL用户名和密码不正确，显示如图7.46所示界面。图7.44MySQL连接成功界面图7.45驱动程序没有装载成功界面图7.46MySQL用户名和密码不正确界面习题

1.在网上阅读ServletAPI文档。

2.请从网上下载Servlet2.5Specification规范来进行阅读。下载地址为：/is-bin/INTERSHOP.enfinity/WFS/CDS-CDS_JCP-Site/en_US/-/USD/ViewFilteredProduct