jsp连接mysql的问题

Question

Class.forName("org.gjt.mm.mysql.Driver");
String url ="jdbc:mysql://localhost/myDB?user=soft&password=soft1234&useUnicode=true&characterEncoding=8859_1"
//myDB为数据库名
Connection conn= DriverManager.getConnection(url);记得在lib下放上驱动包

Answer 1

在项目中先导入那三个数据库的jar包就偶看了！

Answer 2

没有三个JAR包呵
只有一个啊
还有吧哪几个包放在项目德LIB下就刑了吗???

Answer 3

mysql不是MSSQL，看代码
package com.hitv.business.common;import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Iterator;
import java.util.List;public class BaseDB {    private String driverName;
    private String dbURL;
    private String server;
    private String port;
    private String db;
    private String user;
    private String pass;    public BaseDB(){
        try {
            driverName = "com.mysql.jdbc.Driver";
            server = "服务器地址";
            port = "3306";
            db = "数据库名字";
            user = "用户名";
            pass = "密码";
            dbURL = "jdbc:mysql://" + server + ":" + port + "/" + db
                    + "?useUnicode=true&characterEncoding=GBK&user=" + user
                    + "&password=" + pass;
            Class.forName(driverName).newInstance();
        }
        catch (Exception ex) {
            ex.printStackTrace();
        }
    }    public Connection getConnection(){
        Connection conn = null;
        try {
            conn = DriverManager.getConnection(dbURL);
        }
        catch (Exception e) {
            e.printStackTrace();
        }        return conn;
    }    public void closeConnection(Connection conn) throws SQLException {
        try {
            if (conn != null) {
                conn.close();
            }
        }
        catch (SQLException e) {
            throw e;
        }
    }    public void closeStatement(Statement ps) throws SQLException {
        try {
            if (ps != null) {
                ps.close();
            }
        }
        catch (SQLException e) {
            throw e;
        }
    }    public void closeResultSet(ResultSet rs) throws SQLException {
        try {
            if (rs != null) {
                rs.close();
            }
        }
        catch (SQLException e) {
            throw e;
        }
    }
}

Answer 4

数据库连接包
mysql-connector-java-5.0.8.zip

Answer 5

package com.hitv.business.common; import java.io.FileInputStream; 
import java.io.FileNotFoundException; 
import java.io.IOException; 
import java.sql.Connection; 
import java.sql.DriverManager; 
import java.sql.ResultSet; 
import java.sql.SQLException; 
import java.sql.Statement; 
import java.util.Iterator; 
import java.util.List; public class BaseDB {     private String driverName; 
    private String dbURL; 
    private String server; 
    private String port; 
    private String db; 
    private String user; 
    private String pass;     public BaseDB(){ 
        try { 
            driverName = "com.mysql.jdbc.Driver"; 
            server = "服务器地址"; 
            port = "3306"; 
            db = "数据库名字"; 
            user = "用户名"; 
            pass = "密码"; 
            dbURL = "jdbc:mysql://" + server + ":" + port + "/" + db 
                    + "?useUnicode=true&characterEncoding=GBK&user=" + user 
                    + "&password=" + pass; 
            Class.forName(driverName).newInstance(); 
        } 
        catch (Exception ex) { 
            ex.printStackTrace(); 
        } 
    }     public Connection getConnection(){ 
        Connection conn = null; 
        try { 
            conn = DriverManager.getConnection(dbURL); 
        } 
        catch (Exception e) { 
            e.printStackTrace(); 
        }         return conn; 
    }     public void closeConnection(Connection conn) throws SQLException { 
        try { 
            if (conn != null) { 
                conn.close(); 
            } 
        } 
        catch (SQLException e) { 
            throw e; 
        } 
    }     public void closeStatement(Statement ps) throws SQLException { 
        try { 
            if (ps != null) { 
                ps.close(); 
            } 
        } 
        catch (SQLException e) { 
            throw e; 
        } 
    }     public void closeResultSet(ResultSet rs) throws SQLException { 
        try { 
            if (rs != null) { 
                rs.close(); 
            } 
        } 
        catch (SQLException e) { 
            throw e; 
        } 
    } 
}

Answer 6

http://d.download.csdn.net/down/457086/siyue_qi
java连接mysql的jar包

Answer 7

jar包和Mysql的扳本有关系吗????

Answer 8

驱动包是3.18的
mysql是5.0版本的

Answer 9

我用的就是mysql5.0
这个jar包是可以的。
http://d.download.csdn.net/down/457086/siyue_qi