packagecn.tedu.jdbc;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.Statement;publicclassJDBCTest{publicstaticvoidmain(String[] args)throwsException{Class.forName("com.mysql.jdbc.Driver");String url="jdbc:mysql://localhost:3306/school";String user="root";String pwd="root";Connection c =DriverManager.getConnection(url, user, pwd);Statement s = c.createStatement();ResultSet r = s.executeQuery("Select * from courses");while(r.next()){for(int i =1; i <=3; i++){System.out.print(r.getString(i)+" ");}System.out.println();}}}
遍历结果集
//处理结果//1.让游标向下移动一行while(rs.next()){String id = rs.getString(1);String name = rs.getString(2);int age = rs.getInt(3);int pro = rs.getInt(4);System.out.println(id+"---"+name+"---"+age+"---"+pro);}