import java.sql.*;
/**
Connection coon = null;
Statement st =null;
ResultSet rs = null;
//加载驱动
try {
Class.forName("com.mysql.jdbc.Driver");//mysql驱动-固定写法
//创建连接,数据库对象
coon = DriverManager.getConnection("jdbc:mysql://localhost:3317/one","root","root");
//创建执行sql语句对象,执行sql对象
st = coon.createStatement();
//rs = st.executeQuery("Update temp set name = '卤肉饭' where id = 4");
//执行sql语句
//返回的是行数,即表示的是数据库增删该导致了数据库几行数据发生变化
String sql = "update temp set name = '卤肉饭' where id = 3";
int i = st.executeUpdate(sql);
if(i>0){
System.out.println("修改成功!!!");
}
} catch (ClassNotFoundException | SQLException e) {
e.printStackTrace();
}finally {
//关闭连接-----必须写的close 关闭
try {
assert coon != null;
coon.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}电脑运行之后出现
C:\Users\shent\Desktop\jdk1.8.0_111\bin\java.exe "-javaagent:C:\Program Files\JetBrains\IntelliJ IDEA 2019.3.3\lib\idea_rt.jar=54678:C:\Program Files\JetBrains\IntelliJ IDEA 2019.3.3\bin" -Dfile.encoding=UTF-8 -classpath C:\Users\shent\Desktop\jdk1.8.0_111\jre\lib\charsets.jar;C:\Users\shent\Desktop\jdk1.8.0_111\jre\lib\deploy.jar;C:\Users\shent\Desktop\jdk1.8.0_111\jre\lib\ext\access-bridge-64.jar;C:\Users\shent\Desktop\jdk1.8.0_111\jre\lib\ext\cldrdata.jar;C:\Users\shent\Desktop\jdk1.8.0_111\jre\lib\ext\dnsns.jar;C:\Users\shent\Desktop\jdk1.8.0_111\jre\lib\ext\jaccess.jar;C:\Users\shent\Desktop\jdk1.8.0_111\jre\lib\ext\jfxrt.jar;C:\Users\shent\Desktop\jdk1.8.0_111\jre\lib\ext\localedata.jar;C:\Users\shent\Desktop\jdk1.8.0_111\jre\lib\ext\nashorn.jar;C:\Users\shent\Desktop\jdk1.8.0_111\jre\lib\ext\sunec.jar;C:\Users\shent\Desktop\jdk1.8.0_111\jre\lib\ext\sunjce_provider.jar;C:\Users\shent\Desktop\jdk1.8.0_111\jre\lib\ext\sunmscapi.jar;C:\Users\shent\Desktop\jdk1.8.0_111\jre\lib\ext\sunpkcs11.jar;C:\Users\shent\Desktop\jdk1.8.0_111\jre\lib\ext\zipfs.jar;C:\Users\shent\Desktop\jdk1.8.0_111\jre\lib\javaws.jar;C:\Users\shent\Desktop\jdk1.8.0_111\jre\lib\jce.jar;C:\Users\shent\Desktop\jdk1.8.0_111\jre\lib\jfr.jar;C:\Users\shent\Desktop\jdk1.8.0_111\jre\lib\jfxswt.jar;C:\Users\shent\Desktop\jdk1.8.0_111\jre\lib\jsse.jar;C:\Users\shent\Desktop\jdk1.8.0_111\jre\lib\management-agent.jar;C:\Users\shent\Desktop\jdk1.8.0_111\jre\lib\plugin.jar;C:\Users\shent\Desktop\jdk1.8.0_111\jre\lib\resources.jar;C:\Users\shent\Desktop\jdk1.8.0_111\jre\lib\rt.jar;D:\我的项目\jdbc\demo02\out\production\demo02 Test
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:331)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:264)
at Test.main(Test.java:14)
Exception in thread "main" java.lang.NullPointerException
at Test.main(Test.java:33)
Process finished with exit code 1
不知道哪里错了!!
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver数据库驱动包你没导入啊
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver 缺少数据库加载驱动 少jar包了 去下载个mysql驱动jar 导入你的项目里
还有你的数据库端口是3317? 大部分都是3306
如果端口没错 就去找个数据库驱动的jar包 粘进去就行
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver 缺少数据库驱动包
检查驱动包