Class not found exception occur. Message is:org.gjt.mm.mysql.DriverSQL Exception occur. Message is:No suitable driver found for jdbc:mysql://localhost:3306/paradise?user=newman0708;password=123456
1.classpath已经设置好了
export CLASSPATH=.:$JAVA_HOME/lib:$JRE_HOME/lib:$CLASSPATH:$JAVA_HOME/mysql-connector-java-5.1.6-bin.jar
2.jdk是1.6.0
jdbc是5.1.6
下面是程序
<%
try{
Class.forName("org.gjt.mm.mysql.Driver");
//加载 mm.mysql.driver
} catch (java.lang.ClassNotFoundException e)
//如果加载时出错，给出相应的错误信息
{
out.print("Class not found exception occur. Message is:");
out.print(e.getMessage());
}
try{
Connection con;
Statement stmt;
ResultSet rs;
String con_string="jdbc:mysql://localhost:3306";
con_string=con_string+"/paradise?user=newman0708;password=123456";
con = DriverManager.getConnection(con_string);
//创建数据库联接，这样的做法类似于M$的ASP中的创建数据库联接。
stmt = con.createStatement();
//执行插入数据的操作
rs = stmt.executeQuery("SELECT * FROM test");
//把数据库中所有的数据读出来
while(rs.next()){
String s1=rs.getString("name");
String s2=rs.getString("age");
out.println(s1+"<br>");
out.println("<li>"+s2+"<p>");
//打印所显示的数据
}
} catch (SQLException e) {
//如果SQL语句执行的过程中出错，则显示出相应的错误信息
out.print("SQL Exception occur. Message is:");
out.print(e.getMessage());
}
%>
