Tomcat6.0使用jdbc连接池连接mysql--操作步骤介绍

最新推荐文章于 2021-02-10 18:48:42 发布

baojiangeng

最新推荐文章于 2021-02-10 18:48:42 发布

阅读量2.5k

点赞数

文章标签： jdbc tomcat exception import encoding mysql

本文链接：https://blog.csdn.net/baojiangeng/article/details/1811547

版权

参考了部分网友文章，详尽地介绍操作步骤，使读者轻松入门。

1. 安装jdk,tomcat,mysql

jdk 1.5.0 _09:C:/Program Files/Java/jdk 1.5.0 _09

apache-tomcat- 6.0.14 .zip解压到C:/tomcat

mysql_noinstall_5_1_11_beta_win32.zip解压到C:/mysql

mysql-connector-java- 5.1.3 -rc.tar.gz解压到C:/Program Files/Java/jdk1.5.0_09/lib

2. 设置jdbc库classpath环境变量

Path= %JAVA_HOME%/bin;

classpath=.;C:/Program Files/Java/jdk 1.5.0 _09/lib/dt.jar;C:/Program Files/Java/j

dk 1.5.0 _09/lib/tools.jar;C:/tomcat/lib/servlet-api.jar;C:/Program Files/Java/jdk

1.5.0 _09/lib/mysql-connector-java-5.1.3-rc-bin.jar;

CATALINA_HOME=c:/tomcat

JAVA_HOME=C:/Program Files/Java/jdk 1.5.0 _09

3. 部署web服务

PartI C:/tomcat/webapps/DBTest/index.jsp

<%@ page language="java" pageEncoding="UTF-8"%>

<%@ page import ="com.test.*" %>

<html>

<head>

</head>

<body>

DBTest tst = new DBTest();

tst.init();

<h2>Results</h2>

Foo <%= tst.getFoo() %><br>

Bar <%= tst.getBar() %>

</body>

</html>

PartII C:/tomcat/webapps/DBTest/WEB-INF/classes/com/test/DBTest.class

编译,javac –d C:/tomcat/webapps/DBTest/WEB-INF/classes DBTest.java

/*
* DBTest.java
*
* Created on 2007/06/07, 10:33:02
*
* To change this template, choose Tools | Template Manager
* and open the template in the editor.
*/

/**
*
* @author wangzicai
*/
import javax.naming.*;
import javax.sql.*;
import java.sql.*;
public class DBTest {
    String foo = "Not Connected";
    int bar = -1;
    public void init() {
        try{
            Context ctx = new InitialContext();
            if(ctx == null )
                throw new Exception("Boom - No Context");
            DataSource ds =
                    (DataSource)ctx.lookup(
                    "java:comp/env/jdbc/TestDB");
            if (ds != null) {
                Connection conn = ds.getConnection();
                if(conn != null) {
                    foo = "Got Connection "+conn.toString();
                    Statement stmt = conn.createStatement();
                    ResultSet rst =
                            stmt.executeQuery(
                            " select * from test ");
                    if(rst.next()) {
                        foo=rst.getString(1);
                        bar=208;
                    }
                    conn.close();
                }
            }
        }catch(Exception e) {
            e.printStackTrace();
        }
    }
    public String getFoo() { return foo; }
    public int getBar() { return bar;}

    public static void main(String[] args)
    {
    try{
    DBTest db= new DBTest();
    db.init();
    }
    catch(Exception e)
    {e.printStackTrace();
    }
    }
}