Java连接MySQL

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;
   }
}

代码的写法跟Java连接Oracle，Java连接DB2差不多是一样的，只需要更改驱动程序的写法以及导入相应的jar包。

Java连接Oracle：http://www.cnblogs.com/fabulousyoung/p/4076942.html

Java连接DB2：   http://www.cnblogs.com/fabulousyoung/p/4071089.html