注册 登录
编程论坛 MySQL论坛

mysql连接到tomcat是不是需要一个文件拷贝到lib文件夹中,哪里可以得到?

奥丁 发布于 2007-09-30 10:37, 3389 次点击
tomcat6.0
mysql 5.0
12 回复
#2
purana2007-09-30 10:43
mysql连接到tomcat?什么概念?
如果你想用jsp连接mysql的话,容器是tomcat
那你将mysql的驱动文件放到你的webapp/lib下就了
#3
奥丁2007-09-30 10:59
就是这个意思
那个文件哪里可以得到
#4
purana2007-09-30 11:00
mysql官方网站.
#5
奥丁2007-09-30 11:01

那个文件叫什么怎么找啊
我现在有一个 不知道怎么回事就是连不上
想重新弄一个

#6
purana2007-09-30 11:03
那个驱动叫什么都不知道.
那你有的是什么东西?
MySQL Connection/J
#7
奥丁2007-09-30 11:26
mysql-connector-java-5.0.5-bin.jar
是在Tomcat 6.0\lib下
#8
奥丁2007-09-30 11:30
连接不上会不会和版本有关系啊
#9
奥丁2007-09-30 11:34
java.lang.NullPointerException
at com.intacpurun.wsms.comm.Util.getCityList(Util.java:43)
at org.apache.jsp.serviceintroduce_jsp._jspService(serviceintroduce_jsp.java:111)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:852)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:584)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1508)
at java.lang.Thread.run(Thread.java:619)

这个是转到另一页时出现的异常
com.intacpurun.wsms.comm.Util.getCityList
这个方法是用来得到数据库中数据的
#10
purana2007-09-30 17:49

只有本站会员才能查看附件,请 登录

这个驱动包.
将它放到你的web项目文件夹的lib下
如果你用的是NetBeans的话,那只是在库里添加这个jar就可以了.

[CODE]<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>
<%--
The taglib directive below imports the JSTL library. If you uncomment it,
you must also add the JSTL library to the project. The Add Library... action
on Libraries node in Projects view can be used to add the JSTL 1.1 library.
--%>
<%--
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
--%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP</title>
</head>
<body>
<%
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/tennis","root","admin");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select playerno from players");
while(rs.next()){
out.println(rs.getString(1));
}
rs.close();
stmt.close();
con.close();
}catch(Exception exc){
out.print(exc.toString());
}

%>
</body>
</html>[/CODE]


#11
奥丁2007-09-30 19:44

这个问题和使用JDK的版本有关系吗?
学校用的是1.5 我家里用的是1.6

#12
purana2007-09-30 19:54

与jdk无关

[此贴子已经被作者于2007-9-30 19:54:42编辑过]

#13
ming2062007-10-07 18:06

package com.myApp.db.beans;

import javax.naming.Context;
import javax.sql.DataSource;
import javax.naming.InitialContext;
import java.sql.*;
import java.sql.SQLException;
import java.sql.ResultSet;
import java.sql.CallableStatement;
import java.sql.PreparedStatement;
import com.mysql.jdbc.Driver; //这里事先要加入lib中.我用的是NetBeans IDE 5.5开发,直接在库里添加MYSQL的JAR驱动包
import java.lang.Exception;
import java.lang.ClassNotFoundException;
import java.util.Properties;

/**
*@类名:DBConn
*@继承抽象类DB,实现DB内的所有抽象方法
*@
*/
public class DBConn extends DB{

private String driver=null;
private String dbsouser=null;
private String dbUserName=null;
private String dbUserPassWord=null;
private int showDatabaseType=0;
public Connection conn=null;
public Statement stmt=null;

//初始化,获得驱动、数据源等
public DBConn()
//抛出异常
throws ClassNotFoundException
{
/********************
* 0表示为Accese连接
* 1表示为MSSQL连接,
* 2表示为MYSQL连接
*******************
*/
this.showDatabaseType=2;
switch(this.showDatabaseType){

case 0:/***Accese连接方式****/
this.driver="sun.jdbc.odbc.JdbcOdbcDriver";
this.dbsouser="jdbc:odbc:AcceseDB";
this.dbUserName="";
this.dbUserPassWord="";
break;
case 1:/***MSSQL连接方式****/
this.driver="sun.jdbc.odbc.JdbcOdbcDriver";
this.dbsouser="jdbc:odbc:b";
this.dbUserName="sa";
this.dbUserPassWord="moxiaoming";
break;
/********************/
case 2:
/***MYSQL连接方式****/
this.driver="com.mysql.jdbc.Driver";
this.dbsouser="CustomerManagement_db";
this.dbUserName="root";
this.dbUserPassWord="moxiaoming";
break;
/********************/
default:break;
}

try{
Class.forName(getDriver());//连接驱动
}catch(ClassNotFoundException ce){
throw new ClassNotFoundException("找不到驱动......");
}
}

//驱动设置
public String getDriver(){
return driver;
}
public void setDriver(String driver){
this.driver=driver;
}
//数据源设置
public String getDbsouser(){
return dbsouser;
}
public void setDbsouser(String dbsouser){
this.dbsouser=dbsouser;
}
//登陆数据库帐号
public String getDbUserName(){
return dbUserName;
}
public void setDbUserName(String dbUserName){
this.dbUserName=dbUserName;
}
//登陆数据库密码
public String getDbUserPassWord(){
return dbUserPassWord;
}
public void setDbUserPassWord(String dbUserPassWord){
this.dbUserPassWord=dbUserPassWord;
}
//连接
public Connection getConnection()throws SQLException{
try{
//连接数据库
/*Accese\ MSSQL 连接*/
if(this.showDatabaseType==0 || this.showDatabaseType==1){
conn=DriverManager.getConnection(getDbsouser().trim(),
getDbUserName().trim(),
getDbUserPassWord().trim());


}
/*MYSQL 连接*/
else if(this.showDatabaseType==2){
conn=DriverManager.getConnection("jdbc:mysql://localhost/"+getDbsouser()+
"?user="+getDbUserName()+
"&password="+getDbUserPassWord());
}else conn=null;
}catch(SQLException ce){
throw new SQLException("数据库连接出错误!");
}
return conn;
}
//设置连接
public void setConnection(Connection conn){
try{
this.conn=conn;
}catch(Exception ce){
}
}
//关闭Statement对象
public void DBstmtclose()throws Exception{
try{
if(stmt!=null) stmt.close();
}catch(Exception e){
throw e;
}
}
//关闭Connection对象
public void DBconnclose()throws Exception{
try{
if(conn!=null) conn.close();
}catch(Exception e){
throw e;
}
}
}

1