如何连接mysql数据库?

Googled将google应用连接到mysql数据库连接"！

找到以下内容: https://developers.google.com/apps-script/jdbc_overview [

Googled ''connect google apps to mysql database connection''!

Found this: https://developers.google.com/apps-script/jdbc_overview[^]

Is this helpful?

我经常使用jdoconfig.xml文件

< persistence-manager-factory name ="mysqldbconnection">
<属性名称="javax.jdo.PersistenceManagerFactoryClass">
value ="org.datanucleus.store.appengine.jdo.DatastoreJDOPersistenceManagerFactory"/>
<属性名称="javax.jdo.option.ConnectionDriverName" value ="com.mysql.jdbc.Driver">
<属性名称="javax.jdo.option.ConnectionURL" value ="jdbc:mysql://localhost:3306/testproject">
<属性名称="javax.jdo.option.ConnectionUserName" value ="root">
<属性名称="javax.jdo.option.ConnectionPassword" value ="admin">
<属性名称="javax.jdo.option.NontransactionalRead" value ="true">
<属性名称="javax.jdo.option.NontransactionalWrite" value ="true">
<属性名称="javax.jdo.option.RetainValues" value ="true">
<属性名称="datanucleus.appengine.autoCreateDatastoreTxns" value ="true">


demo.java文件:

包june.testproject.client;
导入javax.jdo.JDOHelper;
导入javax.jdo.PersistenceManagerFactory;

导入java.sql.Connection;



公共课程演示{

公共静态void main(String [] argv){

System.out.println("-------- MySQL JDBC连接测试------------");

尝试{

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

} catch(ClassNotFoundException e){

System.out.println(您的MySQL JDBC驱动程序在哪里?");
e.printStackTrace();
返回；

}

System.out.println(已注册MySQL JDBC驱动程序！");
连接connection = null;

//connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/googleapps"，"root"，"admin");
最终的PersistenceManagerFactory pmfInstance = JDOHelper.getPersistenceManagerFactory("mysqldbconnection");
connection =(Connection)pmfInstance;

if(connection！= null){
System.out.println(您成功做到了，现在就控制您的数据库！");
} else {
System.out.println(无法建立连接！");
}
}
}

命令提示符执行

java -cp D:\ Arul \ Googleeclipse \ testproject \ war \ WEB-INF \ lib \ mysql-connector-java-3.1.12-bin.jar; D:\ Arul \ Googleeclipse \ testproject \ src \ june \ testproject \ client演示


发生错误

线程主"中的异常java.lang.NoClassDefFoundError:demo
引起原因:java.lang.ClassNotFoundException:demo
在java.net.URLClassLoader上

i am use to jdoconfig.xml file

<persistence-manager-factory name="mysqldbconnection">
<property name="javax.jdo.PersistenceManagerFactoryClass">
value="org.datanucleus.store.appengine.jdo.DatastoreJDOPersistenceManagerFactory"/>
<property name="javax.jdo.option.ConnectionDriverName" value="com.mysql.jdbc.Driver">
<property name="javax.jdo.option.ConnectionURL" value="jdbc:mysql://localhost:3306/testproject">
<property name="javax.jdo.option.ConnectionUserName" value="root">
<property name="javax.jdo.option.ConnectionPassword" value="admin">
<property name="javax.jdo.option.NontransactionalRead" value="true">
<property name="javax.jdo.option.NontransactionalWrite" value="true">
<property name="javax.jdo.option.RetainValues" value="true">
<property name="datanucleus.appengine.autoCreateDatastoreTxns" value="true">


demo.java file:

package june.testproject.client;
import javax.jdo.JDOHelper;
import javax.jdo.PersistenceManagerFactory;

import java.sql.Connection;



public class demo {

public static void main(String[] argv) {

System.out.println("-------- MySQL JDBC Connection Testing ------------");

try {

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

} catch (ClassNotFoundException e) {

System.out.println("Where is your MySQL JDBC Driver?");
e.printStackTrace();
return;

}

System.out.println("MySQL JDBC Driver Registered!");
Connection connection = null;

//connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/googleapps","root", "admin");
final PersistenceManagerFactory pmfInstance = JDOHelper.getPersistenceManagerFactory("mysqldbconnection");
connection=(Connection) pmfInstance;

if (connection != null) {
System.out.println("You made it, take control your database now!");
} else {
System.out.println("Failed to make connection!");
}
}
}

command prompt execute

java -cp D:\Arul\Googleeclipse\testproject\war\WEB-INF\lib\mysql-connector-java-3.1.12-bin.jar;D:\Arul\Googleeclipse\testproject\src\june\testproject\client demo


error occur

Exception in thread "main" java.lang.NoClassDefFoundError: demo
Caused by: java.lang.ClassNotFoundException: demo
at java.net.URLClassLoader

1.run(未知源)
在java.security.AccessController.doPrivileged(本机方法)
在java.net.URLClassLoader.findClass(未知来源)
在java.lang.ClassLoader.loadClass(未知来源)
在sun.misc.Launcher

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