import java.sql.*; public class javaTest { public static void main(String[] args) throws ClassCastException, SQLException, ClassNotFoundException { //数据库名:imooc;3306是数据库端口 String URL="jdbc:mysql://localhost:3306/imooc?useUnicode=true&characterEncoding=utf-8"; //shengquan连接名 String USER="squan"; String PASSWORD="123456"; //1.加载驱动程序 Class.forName("com.mysql.jdbc.Driver"); //2.获得数据库链接 Connection conn= DriverManager.getConnection(URL, USER, PASSWORD); //3.通过数据库的连接操作数据库,实现增删改查(使用Statement类) Statement st=conn.createStatement(); ResultSet rs=st.executeQuery("select * from user"); //4.处理数据库的返回结果(使用ResultSet类) while(rs.next()){ System.out.println(rs.getString("user_name")+" " +rs.getString("user_password")); } //关闭资源 rs.close(); st.close(); conn.close(); }
}
数据库: