package cn.sql.sqlconn;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class Util { Connection conn=null; public Util(){ // 第一步 try { Class.forName("com.mysql.jdbc.Driver"); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block System.out.println("加载驱动失败"); } //第二步 String url = "jdbc:mysql://10.1.5.205:3306/admin "; String user = "root "; String password = "admin "; try { conn = DriverManager.getConnection(url, user, password) ; } catch (SQLException e) { // TODO Auto-generated catch block System.out.println("数据库连接失败"); } //第三步 操作数据库 try { Statement sta = conn.createStatement(); String sql = "select * from userinfor ; " ; ResultSet rs = sta.executeQuery(sql); while(rs.next()){ String name= rs.getString("name"); String pwd= rs.getString("pwd"); System.out.println("name: "+name + "\n pwd: " +pwd); } //rs.close(); //sta.close(); //conn.close(); } catch (SQLException e) { // TODO Auto-generated catch block System.out.println("数据库连接失败"); } } public static void main(String[] args) { // TODO Auto-generated method stub new Util(); }}