【JDBC】

养乐多&

已于 2023-04-20 10:50:12 修改

阅读量447

点赞数

文章标签： java

于 2021-11-22 16:51:37 首次发布

本文链接：https://blog.csdn.net/weixin_54083813/article/details/121475236

版权

Java JDBC MySQL PreparedStatement ResultSet

关键词由CSDN通过智能技术生成

Class.forName("com.mysql.cj.jdbc.Driver");
String url ="jdbc:mysql://localhost:3306/school?characterEncoding=utf8&serverTimezone=Asia/Shanghai";
Connection conn= DriverManager.getConnection(url,"root","root");
  String sql="select *from car where name=?";
PreparedStatement ps=conn.prepareStatement(sql);
ps.setString(1,"jzl");
ResultSet rs= ps.executeQuery();
while (rs.next()){
   String name= rs.getString(1);
    String color=rs.getString(2);
    Double price= rs.getDouble(3);
    System.out.println(name+color+price);
}
rs.close();
ps.close();
conn.close();