Java --JDBC基础连接

package com.yawj.Test0401JDBC;
import java.sql.*;

public class JDBC {
    public static final String url = "jdbc:mysql://localhost:3306/mytest";
    public static final String root="root";
    public static final String password="1103";

    public static void main(String[] args) throws SQLException, ClassNotFoundException {

            //加载数据库驱动
            Class.forName("com.mysql.jdbc.Driver");
            //获取数据库连接
            Connection conn = DriverManager.getConnection(url,root,password);
            Statement statement = conn.createStatement();
            //Sql语句
            ResultSet resultSet = statement.executeQuery("SELECT * FROM users");
            //循环输出结果
            while (resultSet.next())
            {
                System.out.println(resultSet.getInt("userId")+" "+resultSet.getString("username")
                +" "+resultSet.getString("password"));
            }


    }






}