首先,我正在考虑我的答案,以向您展示与MysqL数据库进行连接的另一种更好的方法,它更容易使用,并且nu-expected Exception 更少。 您需要执行一些步骤:
请参见下面为我提供的示例,下面的示例演示了如何在MysqL上连接和执行查询:
import java.sql.*;
public class MysqLConnection { private String MysqL_DRIVER = “com.MysqL.jdbc.Driver”; private String MysqL_URL = “jdbc:MysqL://localhost:3306/test”;
private Connection con; private Statement st; private ResultSet rs;
public MysqLConnection() {
try {
Class.forName(MysqL_DRIVER);
System.out.println("Class Loaded....");
con = DriverManager.getConnection(MysqL_URL,"","");
System.out.println("Connected to the database....");
st = con.createStatement();
int c =st.executeUpdate("CREATE TABLE Accounts (Name VARCHAR(30))");
System.out.println("Table have been created.");
System.out.println(c+" Row(s) have been affected");
con.close();
} catch(ClassNotFoundException ex) {
System.out.println("ClassNotFoundException:\n"+ex.toString());
ex.printStackTrace();
} catch(sqlException ex) {
System.out.println("sqlException:\n"+ex.toString());
ex.printStackTrace();
}
}
public static void main(String…args) { new MysqLConnection(); } }