JDK变量设定
Path=c:\jdk\bin;
Classpath=.;c:\jdk\lib\tools.jarTomcat变量设定
JAVA_HOME=C:\JDK
CATALINA_HOME=C:\TOMCAT
CLASSPATH=C:\TOMCAT\COMMON\LIB\SERVLET.JAR
PATH=C:\JDK\BINJDBC变量设置
CLASSPATH=C:\tomcat\common\lib
(要把jdbc放在这个目录)我把jdk装在c:\jdk目录
mysql在c:\mysql目录
tomcat在c:\tomcat目录
例子 test.jsp
放在c:\tomcat\webapps\database\test.jsp
database目录下建立WEB-INF(一定要大写)目录
WEB-INF目录下建立classes目录<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url ="jdbc:mysql://localhost/your_db?user=your_id&password=your_password";
Connection conn= DriverManager.getConnection(url);
Statement stmt=conn.createStatement();
String sql="select * from book";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {%>
您的第一个字段内容为:<%=rs.getString(1)%>
您的第二个字段内容为:<%=rs.getString(2)%>
<%}%>
<%out.print("数据库操作成功,恭喜你");%>
<%rs.close();
stmt.close();
conn.close();
%>
</body>
</html>在mysql下你的数据库your_db
create database your_db;
use your_db;
create table book (title varchar(50),price varchar(50));
insert into book (title, price) values ('thinking in java','99');在ie下输入地址
http://localhost:8080/database/test.jsp
Path=c:\jdk\bin;
Classpath=.;c:\jdk\lib\tools.jarTomcat变量设定
JAVA_HOME=C:\JDK
CATALINA_HOME=C:\TOMCAT
CLASSPATH=C:\TOMCAT\COMMON\LIB\SERVLET.JAR
PATH=C:\JDK\BINJDBC变量设置
CLASSPATH=C:\tomcat\common\lib
(要把jdbc放在这个目录)我把jdk装在c:\jdk目录
mysql在c:\mysql目录
tomcat在c:\tomcat目录
例子 test.jsp
放在c:\tomcat\webapps\database\test.jsp
database目录下建立WEB-INF(一定要大写)目录
WEB-INF目录下建立classes目录<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url ="jdbc:mysql://localhost/your_db?user=your_id&password=your_password";
Connection conn= DriverManager.getConnection(url);
Statement stmt=conn.createStatement();
String sql="select * from book";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {%>
您的第一个字段内容为:<%=rs.getString(1)%>
您的第二个字段内容为:<%=rs.getString(2)%>
<%}%>
<%out.print("数据库操作成功,恭喜你");%>
<%rs.close();
stmt.close();
conn.close();
%>
</body>
</html>在mysql下你的数据库your_db
create database your_db;
use your_db;
create table book (title varchar(50),price varchar(50));
insert into book (title, price) values ('thinking in java','99');在ie下输入地址
http://localhost:8080/database/test.jsp
jdbc connector要自己下载。
http://www.mysql.com/downloads