话不多说,配置步骤如下:
1.安装JDK,并进行环境变量配置;
2.安装Tomcat并进行环境变量配置:classpath=D:/j2sdk1.4.2_05/LIB/dt.JAR;D:/j2sdk1.4.2_05/LIB/TOOLS.JAR;D:/j2sdk1.4.2_05/BIN;d:/mysql_jdbc/mysql-connector-java-3.0.15-ga-bin.jar;d:/mysql_jdbc/lib.;
JAVA_HOME=d:/j2sdk1.4.2_05
TOMCAT_HOME=d:/jakarta-tomcat-4.1.30
3.安装MYSQL, 并进行环境变量配置;
后启动MYSQL服务器;
4.下载MYSQL_JDBC, 下载网址: http://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-3.0.15-ga.zip/from/pick
5.解压并将mysql-connector-java-3.0.15-ga-bin.jar复制到tomcat安装目录/commmon/lib/
6.编写.jsp代码:代码如下:
<html>
<head>
<title>使用JDBC连接数据库</title>
</head>
<body><Font Color="Blue">
<center>
<%@page language="java" %>
<%@page import ="java.sql.Connection" %>
<%@page import ="java.sql.DriverManager" %>
<%@page import ="java.sql.SQLException" %>
<%@page contentType="text/html;charset=GB2312"%>
<%
try
{
Class.forName("com.mysql.jdbc.Driver").newInstance();
}
catch (Exception ex)
{
out.println("Error"+ex);
}
try {
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/family?user=root&password=admin");
if(!conn.isClosed())
out.print("成功连接至数据库!");
conn.close();
} catch (SQLException ex) {
out.println("SQLException: " + ex.getMessage());
out.println("SQLState: " + ex.getSQLState());
out.println("VendorError: " + ex.getErrorCode());
}
%>
</center>
</body>
</html>
好了:试试吧
windows2000Server+j2sdk1.4.2_05
175
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
