P332 Example11_1

任务详情

教材p332 Example11_1

1. 修改数据库的表R1001改为R+自己学号后四位，张三改为自己姓名
2. 提交运行结果截图

代码

import java.sql.*;
public class Examplell_ 1 {
public static void main(String args[]) {
Connection con-null;Statement sql;Resultset rs;
try{ Class. forName ("com. mysq1. jdbc . Driver");//加栽JDBC-MySQL駆功

catch (Exception e){}
string uri = "jdbc:mysql://localhost:3306/students?usessl-true";String user ="root";String password ="";try{
con = DriverManager .getConnection (uri, user, password); //達接代月

}
catch (SQLException e) { }try {
sql-con.createstatement (》;
rs=sq1 . executeQuery("SLzcr * FROM mess"); //査詢 mess表while(rs.next()) {
string number-s .getstring(1);string name-rs.getstring(2) ;Date date=ts . getDate (3) ;
float height=rs ·getFloat(4) ;
system.out.printf ("%s\t"，number) ;System. out.printf ("bs\t"name) ; System.out.printf ("Gs\t"，date》;
system. out .printt ("b.2f\n"，height);

con.closel;

截图

{{uploading-image-661523.png(uploading...)}}

代码链接

https://gitee.com/yukungbhy/yukun-20155335/blob/fff3c606b15e77e4bc6d3a0a61837f4b38d2454b/20155335/Example11_1.java