这是我正在使用的代码,用于连接到mysql数据库。
我收到此错误:类型不匹配:无法从java.sql.statement转换为com.mysql.jdbc.Statement
行:Statement getData = con.createStatement(); //错误
我是否有课程加载问题?
//connect to database
import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Date;
import com.mysql.jdbc.Statement;
public class dbconn {
public static void main(String args[]) {
String username = "username";
String password = "password";
String url = "jdbc:mysql://localhost:3306/Databasename";
try {
Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection(url, username, password);
Statement getData=con.createStatement(); //ERROR HERE
ResultSet rs = getData.executeQuery("select * from MY_TABLE_NAME");
while(rs.next())
System.out.println(rs.getDate(1));
con.close();
}catch(Exception e) {System.out.println(e);}
}
}