整理一下大概分为5个步骤,不要忘记导入连接数据库的jar包
package jdbc_demo;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class ceshi {
public static void insertDemo() throws ClassNotFoundException, SQLException {
// 1. 注册驱动
Class.forName("com.mysql.jdbc.Driver");
// 2. 获取数据库连接
Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/doubleseven", "root", "ROOT");
// 3. 获取执行语句的平台对象
Statement stat = connection.createStatement();
// 4. 执行sql语句
String sql = "insert into student values(null,'阿飞','男','1')";
int row = stat.executeUpdate(sql);
// 5. 处理结果
System.out.println(row>0 ? "添加成功" : "添加失败");
stat.close();
connection.close();
}
public static void main(String[] args) throws ClassNotFoundException, SQLException {
insertDemo();
}
}