误打误撞（一）竟然入门了Eclipse,Tomcat,Mysql-Connection,JSP,Servlet。

误打误撞，竟然入门了Eclipse,Tomcat,Mysql-Connection,JSP,Servlet。

可以开发一个动态网页程序，
可以访问MySQL数据库
可以提交一个表单数据到Servlet。

 

一、准备工作
1.安装JDK6
配置环境变量

CLASSPath = .;C:/Program Files/Java/jdk1.6.0_23/jre/lib;C:/Program Files/Java/jdk1.6.0_23/lib;

JAVA_HOME = C:/Program Files/Java/jdk1.6.0_23

Path = C:/Program Files/Java/jdk1.6.0_23/bin/

 

2.下载Tomcat解压安装
7.0版本

 

3.下载Eclipse解压安装
最新的for Java EE developer版本
设置JRE目录

 

4.下载mysql-connection-5.5.12.jar

二、开发工作
1.打开Eclipse

 

2.创建一个dynamic web project
命名为TestWeb
选Tomcat7为服务器

 

3.拷贝mysql-connection.jar到工程目录

TestWeb/WebContent/WEB-INF/lib

 

4.新建一个index.jsp
TestWeb/WebContent/index.jsp

body内容:

hello, world.
current time is <%=new Date() %>
<form action="/TestWeb/HelloServlet" method="post">
<input type="text" id="p" name="p"/>
<input type="submit" value="click"/>
</form>

 

5.新建一个Servlet
TestWeb/Src/HelloServlet.java

 

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  // TODO Auto-generated method stub
  response.getWriter().write("hello, world.");
 }

//用来响应index.jsp中form的Action.
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  // TODO Auto-generated method stub
  String p = request.getParameter("p");
  response.getWriter().write(p);
 }

 

6.新建一个Servlet
TestWeb/Src/TestServlet.java

 

import java.io.IOException;
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 com.mysql.*;
import com.mysql.jdbc.*;
import java.sql.*;
import java.sql.Statement;

/**
 * Servlet implementation class TestServlet
 */
@WebServlet("/TestServlet")
public class TestServlet extends HttpServlet {
 private static final long serialVersionUID = 1L;
      
    /**
     * @see HttpServlet#HttpServlet()
     */
    public TestServlet() {
        super();
        // TODO Auto-generated constructor stub
       
        try {
   Class.forName("com.mysql.jdbc.Driver").newInstance();
  } catch (InstantiationException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  } catch (IllegalAccessException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  } catch (ClassNotFoundException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
    }

 /**
  * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
  */
 protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  // TODO Auto-generated method stub
  java.sql.Connection conn = null;
  try{
   String strConn = "jdbc:mysql://192.168.100.31/tuge?" +
                                   "user=admin&password=123";
   conn = DriverManager.getConnection(strConn);
   
   String sql = "select * from datasource";
   
   Statement stmt = conn.createStatement();
   ResultSet rs = stmt.executeQuery(sql);
   
   while(rs.next()){
    response.getWriter().write(rs.getString("Name"));
   }
   
   stmt.close();
   rs.close();
  }
  catch(SQLException ex){
   
  }
  finally{
   try{
    conn.close();
   }catch(SQLException ex1){
   }
  }
 }

 /**
  * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
  */
 protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  // TODO Auto-generated method stub
 }

}

 

7.点Run as 就可以启动Tomcat ，跑index.jsp页面了。

 

三、部署工作

在Tomcat安装目录，找到webapps，新建一个目录TestWeb

把工程目录TestWeb/WebContent/下的全部文件拷贝到webapps/TestWeb目录

把工程目录TestWeb/build/下的classes目录拷贝到webapps/TestWeb/WEB-INF/

bingo.

关掉你的eclipse.

重新启动tomcat.

就可以在浏览器中访问 http://localhost:8080/TestWeb/ 了。