IDC资讯中心
运行环境: jdk 5.0 + tomcat 5.5.4+mysql4.1.8
jdk安装路径: d:\java\jdk1.5.0_01
tomcat安装路径:d:\tomcat 5.5
设置环境变量(控制面板->系统->高级):
java_home=d:\java\jdk1.5.0_01
path=%java_home%\bin
classpath=.;d:\java\jdk1.5.0_01\lib\dt.jar;d:\java\jdk1.5.0_01\lib\tools.jar;d:\tomcat 5.5\common\lib\mysql-connector-java-3.1.6-bin.jar;
其中d:\tomcat 5.5\common\lib\mysql-connector-java-3.1.6-bin.jar;是mysql的jdbc驱动,connect/j 3.1.6,可到mysql官方网站下载
tomcat5.5虚拟目录设定:
d:\tomcat 5.5\conf\catalina\localhost下新加一test.xml
内容如下:
<context path="/test" docbase="d:/www" reloadable="true" crosscontext="true" debug="0" >
</context>
d:\www路径将是我们测试网站的根目录,通过http://localhost:8080/test访问该虚拟目录
d:\www下建有目录web-inf,下有web.xml设置文件(可参考d:\tomcat 5.5\webapps\root\web-inf\web.xml),classes目录和lib目录
//连接数据库的java bean文件名dbconn.java
package ningoo;
import java.sql.*;
public class dbconn {
public dbconn() {
}
//declare variable
private connection conn = null;
resultset rs = null;
private string server = "127.0.0.1";
private string port = "3306";
private string db = "test";
private string user = "root";
private string pass = "password";
private string drivername="com.mysql.jdbc.driver";
private string url="jdbc:mysql://"+server+":"+port+"/"+db+"?user="+user+"&password="+pass;
public connection getconn(){//get database connection
try{
class.forname(drivername).newinstance();
conn = drivermanager.getconnection(url);
}
catch(exception e){
e.printstacktrace();
}
return this.conn ;
}
public void setserver(string str) {//set server name
server=str;
}
public void setport(string str) {//set server port
port = str;
}
public void setdb(string str) {//set db name
db = str;
}
public void setuser(string str) {//set user name
user = str;
}
public void setpass(string str) {//set user name
pass = str;
}
public resultset executesql(string str) {
try{
statement stmt = conn.createstatement();
rs = stmt.executequery(str);
}
catch(exception e){
e.printstacktrace();
}
return this.rs;
}
}
编译javac welcome.java,将编译后的文件welcome.class放到目录d:\www\web-inf\classes\ningoo\下
//调用java bean的jsp文件test.jsp
<%@ page contenttype="text/html;charset=gb2312" import="java.sql.*"%>
<jsp:usebean id="ningoo" scope="page" class="ningoo.dbconn" />
<%
resultset rs = null;
connection conn = null;
ningoo.setserver("127.0.0.1"); //设置mysql的服务器名或者ip
ningoo.setport("3306"); //设置mysql的监听端口
ningoo.setdb("test"); //设置mysql的数据库名
ningoo.setuser("root"); //设置连接mysql的用户名
ningoo.setpass("password"); //设置连接mysql的密码
conn = ningoo.getconn() ;
rs = ningoo.executesql("select * from test");
while(rs.next()) {
%>
row:<%=rs.getstring(1)%>
<%}%>
<%out.print("successful!\n");%>
<%
rs.close();
conn.close();
%>
然后在浏览器中访问http://localhost:8080/test/test.jsp,恭喜成功!
