Eclipse jsp连接mysql？

[xiaokonglongdan]

同样的代码，添加了mysql-connector-java-5.1.15-bin.jar到Build Path。

<%@ page import="com.mysql.jdbc.Driver" %>

<%@ page import="java.sql.*" %>

<%
//驱动程序名

String driverName="com.mysql.jdbc.Driver";

//数据库用户名

String userName="kong";

//密码

String userPasswd="kong";

//数据库名

String dbName="clientsmanager";

//表名

String tableName="customer";

//联结字符串

String url="jdbc:mysql://localhost/"+dbName+"?user="+userName+"&password="+userPasswd;

Class.forName("com.mysql.jdbc.Driver").newInstance();

Connection connection=DriverManager.getConnection(url);

Statement statement = connection.createStatement();

String sql="SELECT * FROM "+tableName;

在netbean里面可以连接，在eclipse里面出错。显示找不到Class.forName("com.mysql.jdbc.Driver");
如果注释掉改行就出现：
No suitable driver found for jdbc:mysql://localhost/clientsmanager?user=kong&password=kong
这是怎么回事？

[LoongMint]

你的项目里添加了 mysql 的jar包了吗？确定将它加入到lib中。这个是因为找不到mysql的JDBC驱动

[again_001]

没类库 怎么去实例化对象

[traceofsun]

eclipse中是否引入了mysql连接的jar包？

[again_001]

package org.cs.jdbc;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class BaseConn {
public static void main(String[] args) throws Exception {
temp("zhangsan");
}

public static void temp(String name) throws SQLException {

ResultSet rs = null;
PreparedStatement ps=null;
Connection conn = null;
try {
conn = JDBCSing.getConnection();
String sql = "select id, name from temp where name=?";
ps = conn.prepareStatement(sql);
ps.setString(1, name);
rs = ps.executeQuery();
while (rs.next()) {
System.out.println(rs.getObject("id") + "\t" + rs.getObject("name"));
}
} finally {
JDBCSing.closes(rs, ps, conn);
}
}
}
package org.cs.jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public final class JDBCSing {
private static String driver = "com.mysql.jdbc.Driver";
private static String url = "jdbc:mysql://localhost:3306/emp";
private static String user = "root";
private static String password = "";

private JDBCSing() {
}

private static JDBCSing instance = null;

public static JDBCSing getInstance() {
if (instance == null) {
synchronized (JDBCSing.class) {
if (instance == null)
instance = new JDBCSing();
}
}
return instance;
}

static {
try {
Class.forName(driver);
} catch (ClassNotFoundException e) {
throw new ExceptionInInitializerError(e);
}
}

public static Connection getConnection() throws SQLException {
return DriverManager.getConnection(url, user, password);
}

public static void closes(ResultSet rs, Statement st, Connection conn) {
try {
if (rs != null) {
rs.close();
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
if (st != null) {
st.close();
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
if (conn != null) {
conn.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
}

[wang1986614]

数据库驱动包！

[wo592351033]

"Class.forName("com.mysql.jdbc.Driver").newInstance()"中newInstance()去掉看看！不需写创建实例

[xiaokonglongdan]

[Quote=引用 7 楼 wo592351033 的回复:]

"Class.forName("com.mysql.jdbc.Driver").newInstance()"中newInstance()去掉看看！不需写创建实例
[/Quote]
去掉可以，为什么加上就会找不到呢？驱动里确实有该类。

[suchcl]

为什么不用写创建实例啊。等待中。

[我不是IT男]

String url="jdbc:mysql://localhost/"+dbName+"?user="+userName+"&password="+userPasswd;

您的端口号呢 、 3306

[suchcl]

[Quote=引用 12 楼 hj_sunflower 的回复:]

Java code
String url="jdbc:mysql://localhost/"+dbName+"?user="+userName+"&password="+userPasswd;




您的端口号呢 、 3306
[/Quote]默认的端口号可以不写的。

[jackmis]

Class.forName("com.mysql.jdbc.Driver")

[hejun136]

 Class.forName("com.mysql.jdbc.Driver");
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","sa","123");

[Horrison]

eclipse中是否引入了mysql连接的jar包？

[xiaokonglongdan]

[Quote=引用 16 楼 huozhicheng 的回复:]

eclipse中是否引入了mysql连接的jar包？
[/Quote]
引入了，也可以导入Driver类，但是用Class.forName("com.mysql.jdbc.Driver")的时候就报错，找不到该类。

[wshcdr]

Class.forName("com.mysql.jdbc.Driver");
		//创建指定数据库的URL
		String url = "jdbc:mysql://localhost:3306/test"; 
		String userName = "root"; //root是MySQL默认的用户名
		String password = "123456"; //123是你设置的MySQL密码
		//创建连接
		Connection conn = DriverManager.getConnection(url, userName,password);
		//创建Statement对象
		Statement stmt = conn.createStatement();
		
		

ResultSet rs = stmt.executeQuery("select * from table1");

[wshcdr]

WEB-INF/lib
下是 mysql-connector-java-5.1.7-bin.jar