误打误撞,竟然入门了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/ 了。