首先感谢之前帮助过我的人。
我目前遇到的问题是这行代码
statement.executeUpdate(myTableName);
或者用这些代码行
String myTableName = "CREATE TABLE AgentDetail ("
+ "idNo INT(64) NOT NULL AUTO_INCREMENT,"
+ "initials VARCHAR(2),"
+ "agentDate DATE,"
+ "agentCount INT(64))";
当代码到达这些点时,它会生成一个错误,该错误由 SQLException 块捕获。
要么非常简单,要么非常复杂
任何人都可以指出这个 Java MySQL 编程新手在哪里犯了错误,希望不是错误,提前致谢
这是完整代码的其余部分
public class DbStuff {
private String jdbcDriver = "com.mysql.jdbc.Driver";
private String dbAddress = "jdbc:mysql://localhost:3306/";
private String userPass = "?user=root&password=";
private String dbName = "TIGER19";
private String userName = "root";
private String password = "";
private PreparedStatement preStatement;
private Statement statement;
private ResultSet result;
private Connection con;
public DbStuff() {
try {
Class.forName(jdbcDriver);
con = DriverManager.getConnection(dbAddress + dbName, userName, password);
}
catch (ClassNotFoundException e) {
e.printStackTrace();
}
catch (SQLException e) {
createDatabase();
createTableCub1();
}
}
private void createDatabase() {
try {
Class.forName(jdbcDriver);
con = DriverManager.getConnection(dbAddress + userPass);
Statement s = con.createStatement();
int myResult = s.executeUpdate("CREATE DATABASE IF NOT EXISTS " + dbName);
}
catch (ClassNotFoundException | SQLException e) {
e.printStackTrace();
}
}
private void createTableCub1() {
String myTableName = "CREATE TABLE AgentDetail ("
+ "idNo INT(64) NOT NULL AUTO_INCREMENT,"
+ "initials VARCHAR(2),"
+ "agentDate DATE,"
+ "agentCount INT(64))";
try {
Class.forName(jdbcDriver);
con = DriverManager.getConnection(dbAddress + dbName, userName, password);
statement = con.createStatement();
//The next line has the issue
statement.executeUpdate(myTableName);
System.out.println("Table Created");
}
catch (SQLException e ) {
System.out.println("An error has occurred on Table Creation");
}
catch (ClassNotFoundException e) {
System.out.println("An Mysql drivers were not found");
}
}
}
首先感谢您的帮助和建议。这确实非常有帮助。
结果我学到了三件事,
- 如何编写有关如何创建表格的正确说明。
- 如何用 Java 创建 MySQL 表。
- Smit说的,就是读取e.printStackTrace()信息。
这是我想出的代码。
private void createTableCub1() {
String myTableName = "CREATE TABLE AgentDetail ("
+ "idNo INT(64) NOT NULL AUTO_INCREMENT,"
+ "initials VARCHAR(2),"
+ "agentDate DATE,"
+ "agentCount INT(64), "
+ "PRIMARY KEY(idNo))";
try {
Class.forName(jdbcDriver);
con = DriverManager.getConnection(dbAddress + dbName, userName, password);
statement = con.createStatement();
//This line has the issue
statement.executeUpdate(myTableName);
System.out.println("Table Created");
}
catch (SQLException e ) {
System.out.println("An error has occured on Table Creation");
e.printStackTrace();
}
catch (ClassNotFoundException e) {
System.out.println("An Mysql drivers were not found");
}
}
当然,我欢迎并感谢任何和所有反馈
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)