package javase.jdbc; import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;import java.sql.ResultSet;import java.sql.Statement; public class TestJDBCMysql {   private static Connection con = null;   private static Statement sql = null;   private static ResultSet rs = null;    public static void main(String[] args) throws SQLException {      int no;      String dep;      String sal;      try {        con = dbConn("root", "123456");        if (con == null) {           System.out.print("连接失败");           System.exit(0);        }        sql = con.createStatement();        rs = sql.executeQuery("select empid, deptid, salary from employee");        System.out.println("工号" + "            " + "部门号" + "             "              + "薪水");        while (rs.next()) {           no = rs.getInt(1);           dep = rs.getString(2);           sal = rs.getString(3);           System.out.println(no + "         " + dep + "         " + sal);        }      } catch (Exception e) {        e.printStackTrace();       } finally {        con.close();      }   }    public static Connection dbConn(String name, String pass) {      Connection c = null;      try {        Class.forName("com.mysql.jdbc.Driver");      } catch (ClassNotFoundException e) {        e.printStackTrace();      }      try {        c = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/test",              name, pass);      } catch (SQLException e) {        e.printStackTrace();      }      return c;   }}