我一直在尝试将Java应用程序连接到MySQL数据库,并使用以下代码行:
import java.sql.*;
public class AcceptValues extends HttpServlet {
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String url = "jdbc:mysql://localhost:3306/db_name";
String driver = "com.mysql.jdbc.Driver";
String userName = "root";
String password = "";
try {
Class.forName(driver);
Connection conn = DriverManager.getConnection(url,userName,password);
out.print("Connection estd");
Statement st = conn.createStatement();
st.executeQuery("insert into table_name values(2, 'testing');");
}
conn.close();
} catch (Exception e) {
out.print("Error : " +e.getMessage());
}
}
}
我还将类名设置为从mysql网站下载的mysql-connector-
java-5.1.29-bin.jar。但是我仍然无法使用上述代码行连接到数据库,并且将 ex。com.mysql.jdbc.Driver
抛出错误。
我是Java开发的新手,任何帮助将不胜感激。谢谢。