import java.sql.*;
class JdbcTest {
public static void main(String[] args) {
String sno;
String sname;
String ssex;
String sage;
String query = ("SELECT * FROM Student WHERE Ssex ='男'");
try {
Class.forName("org.gjt.mm.mysql.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost/mysql");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(query);
while (rs.next()) {
sno = rs.getString("Sno");
sname = rs.getString("Sname");
ssex = rs.getString("Ssex");
sage = rs.getString("Sage");
System.out
.println(sno + " " + sno + " " + ssex + " " + sage);
}
con.close();
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
catch(SQLException e){
e.printStackTrace();
}
}
}为何总是出现错误,数据库的数据驱动我已经设置好了,Classpath中设置了mysql的路径
在Eclipse中的结果为
java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at com.java.qijian.JdbcTest.main(JdbcTest.java:12)在dos中的结果为:
java.sql.SQLException: No suitable driver found for jdbjdbc:mysql:studentent
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at JdbcTest.main(JdbcTest.java:11)
class JdbcTest {
public static void main(String[] args) {
String sno;
String sname;
String ssex;
String sage;
String query = ("SELECT * FROM Student WHERE Ssex ='男'");
try {
Class.forName("org.gjt.mm.mysql.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost/mysql");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(query);
while (rs.next()) {
sno = rs.getString("Sno");
sname = rs.getString("Sname");
ssex = rs.getString("Ssex");
sage = rs.getString("Sage");
System.out
.println(sno + " " + sno + " " + ssex + " " + sage);
}
con.close();
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
catch(SQLException e){
e.printStackTrace();
}
}
}为何总是出现错误,数据库的数据驱动我已经设置好了,Classpath中设置了mysql的路径
在Eclipse中的结果为
java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at com.java.qijian.JdbcTest.main(JdbcTest.java:12)在dos中的结果为:
java.sql.SQLException: No suitable driver found for jdbjdbc:mysql:studentent
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at JdbcTest.main(JdbcTest.java:11)
JDBC驱动程序那个jar文件要放置到Tomcat的对应目录
你的classpath中要设定的是那个jar文件的path
你试试jdbcTemplate吧,很好用,根本不用写这些try了
有时间自己好好查查资料.