import java.sql.*;
import java.util.TimeZone;
public class a11 {
public static void main(String[] args) throws SQLException, ClassNotFoundException {
// 加载JDBC驱动,这个不变一直都是这个,无需改变
Class.forName("com.mysql.cj.jdbc.Driver");
// 建立数据库连接,3306后面的a1是数据库的名字,你要先去创建一个数据库,后面是账号和密码
Connection conn = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/a1?serverTimezone=Asia/Shanghai", "root", "123456");
PreparedStatement preStmt ;
String sql = "INSERT INTO a1(age,id,name)"
+ "VALUES(?,?,?)";
// 1.创建执行SQL语句的PreparedStatement对象
preStmt = conn.prepareStatement(sql);
// 2.为SQL语句中的参数赋值
preStmt.setString(1, "555999");
preStmt.setString(2, "123456");
preStmt.setString(3, "16");
// 3.执行SQL
preStmt.executeUpdate();
String sql1 = "SELECT * FROM a1";
ResultSet rs = preStmt.executeQuery(sql1);
// 处理查询结果,这里有三个字段,id,name,age.
while (rs.next()) {
int id = rs.getInt("id");
String name = rs.getString("name");
int age = rs.getInt("age");
System.out.println(id + " " + name + " " + age);
}
}
}
jdbc增加数据和查看数据,没有servlet
最新推荐文章于 2024-07-20 17:05:18 发布