只建立一个类,代码如下:importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.Statement;publicclassTt{publicstaticfinalStringDBDRIVER="org.gjt.mm.mysql.Dr...
只建立一个类,代码如下:
import java.sql.Connection ;import java.sql.DriverManager;import java.sql.Statement;public class Tt{ public static final String DBDRIVER="org.gjt.mm.mysql.Driver" ; public static final String DBURL="jdbc:mysql://localhost:3306/mldn1"; public static final String DBUSER="root"; public static final String DBPASS="mysql";
public static void main(String args[]) throws Exception{ Connection conn=null; Statement stmt=null; try{ Class.forName(DBDRIVER); }catch(ClassNotFoundException e){ e.printStackTrace(); } String sql="insert into person(id,name,password)values('1','lily','123')"; conn=DriverManager.getConnection(DBURL,DBUSER,DBPASS); stmt=conn.createStatement(); stmt.executeUpdate(sql); stmt.close(); conn.close(); }}
报错:
java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver at java.net.URLClassLoader$1.run(URLClassLoader.java:200) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:188) at java.lang.ClassLoader.loadClass(ClassLoader.java:307) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301) at java.lang.ClassLoader.loadClass(ClassLoader.java:252) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:169) at Tt.main(Tt.java:14)Exception in thread "main" java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/mldn1 at java.sql.DriverManager.getConnection(DriverManager.java:602) at java.sql.DriverManager.getConnection(DriverManager.java:185) at Tt.main(Tt.java:20)
MyEclipse连接Mysql已经测试工程,且直接用文本编辑此程序,用javac命令可成功
展开