java JDBC编程

Question

我在命令提示符下工作这是我的代码

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class JDBC {

    static {

        try {

            Class.forName("com.mysql.jdbc.Driver");
        } catch (ClassNotFoundException cnf) {
            System.out.println("Driver could not be loaded: " + cnf);
        }
    }

    public static void main(String[] args)
    {
        String connectionUrl = "jdbc:mysql://localhost:3306/mysql";
        String dbUser = "root";
        String dbPwd = "admin";
        Connection conn;
        ResultSet rs;
        String queryString = "SELECT ID, NAME FROM exptable";

        try {
            conn = DriverManager.getConnection(connectionUrl, dbUser, dbPwd);
            Statement stmt = conn.createStatement();

            // INSERT A RECORD
            stmt.executeUpdate("INSERT INTO exptable (name) VALUES (\"TINU K\")");

            // SELECT ALL RECORDS FROM EXPTABLE
            rs = stmt.executeQuery(queryString);

            System.out.println("ID \tNAME");
            System.out.println("============");
            while (rs.next()) {
                System.out.print(rs.getInt("id") + ".\t" + rs.getString("name"));
                System.out.println();
            }
            if (conn != null) {
                conn.close();
                conn = null;
            }
        } catch (SQLException sqle) {
            System.out.println("SQL Exception thrown: " + sqle);
        }
    }
}

我犯了这样的错误 java.lang.ClassNotFoundException和java.sql.SQLException 那么我可以知道我犯了什么错误吗

Answer 1

您可能错过了java命令中的类路径。从命令提示符执行时，必须在命令中同时提到类路径

java-cp

ex:
java -cp /home/test/jars:/home/test/src com.test.Lab