1、安装jdk
2、安装tomcat
3、安装tomcat admin
相关配置如下:把ADMIN 下的,如目录:(E:/工具/tomcat/jakarta-tomcat-5.5.9-admin/jakarta-tomcat-5.5.9/conf/Catalina/localhost)ADMIN.XML文件拷贝到TOMCAT路径下,如目录:( C:/Program Files/Apache Software Foundation/Tomcat 5.5/conf/Catalina/localhost)LOCALHOST文件夹下。将ADMIN解压包下的,如目录:(E:/工具/tomcat/jakarta-tomcat-5.5.9-admin/jakarta-tomcat-5.5.9/server/webapps/admin)ADMIN整个文件夹拷贝到TOMCAT目录如:(C:/Program Files/Apache Software Foundation/Tomcat 5.5/server/webapps)目录下
这样TOMCAT就可以进入ADMIN管理界面
但此时tomcat还不能运行界面
需要把JDK下的如目录:(C:/Program Files/Java/jdk1.5.0_06/lib)下的tolls.jar拷贝到TOMCAT如目录:(C:/Program Files/Apache Software Foundation/Tomcat 5.5/common/lib)下
这样tomcat就能运行简单的jsp页面
用下面代码测试
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head>
<body>
<%out.println("ok");
%>
<%=new java.util.Date()%>
你好!
</body>
</html>
但还不能连接数据库
需要把三个驱动包msbase.jar mssqlserver.jar msutil.jar 拷贝到TOMCAT如目录:(C:/Program Files/Apache Software Foundation/Tomcat 5.5/common/lib)下
这样就可以连接数据库了
用下面代码测试:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test";
String user="sa";
String password="";
Connection conn=DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from person";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {
%>
您的第一个字段内容为:<%=rs.getString(1)%>
您的第二个字段内容为:<%=rs.getString(2)%>
<%
}
out.print("数据库操作成功,恭喜你");
rs.close();
stmt.close();
conn.close();
%>
</body>
</html>