import com.mysql.jdbc.Driver;
import java.sql.*;
public class jdbc_demo1 {
public static void main(String[] args) throws SQLException {
//加载驱动
DriverManager.registerDriver(new Driver());
//连接数据库
String url ="jdbc:mysql://127.0.0.1:3306/ooo";
String username = "root";
String password = "123456";
Connection connection = DriverManager.getConnection(url, username, password);
//操作数据表
String sql ="select * from user";
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery(sql);
while (resultSet.next()){
System.out.println(resultSet.getObject(1)+" ");
System.out.println(resultSet.getObject(2)+" ");
System.out.println(resultSet.getObject(3)+" ");
System.out.println(resultSet.getObject(4)+" ");
System.out.println();
}
resultSet.close();
statement.close();
connection.close();
}
}