Java 通过 jdbc 连 MySql及SQL Server 2008

1. 下载jdbc连接jar包

2.导入jar包

- msbase.jar、mssqlserver.jar，msutil.jar for sqlserver

- mysql-connector-java-3.0.16-ga-bin.jar for mysql

3.连sqlserver查询

import java.sql.*;

public class Hello {

	private static Connection con;
	private static Statement stmt;
	private static ResultSet rst;
	public static void main(String[] args) {
		try {
            
            Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
            con = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=MyDB","sa","1234");
            stmt = con.createStatement();
            rst = stmt.executeQuery("select * from Users;");
            while(rst.next())
            {
        	    System.out.println();
        	    System.out.println(rst.getInt("UserID"));
        	    System.out.println(rst.getString("Username"));
        	    System.out.println(rst.getString("Password"));
        	    System.out.println(rst.getString("Email"));
        	    System.out.println(rst.getString("Address"));
        	    System.out.println();
            }
            
        } catch (SQLException ex) {
            ex.printStackTrace();
        } catch (InstantiationException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (IllegalAccessException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
        	try {
        		if(!con.isClosed())
        			con.close();
				if(!rst.isClosed())
					rst.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
        }
    }
}

输出:

4.连接mysql查询

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class Hello2 {

	private static Connection con;
	private static Statement stmt;
	private static ResultSet rst;
	public static void main(String[] args) {
		try {
            
            Class.forName("com.mysql.jdbc.Driver").newInstance();
            con = DriverManager.getConnection("jdbc:mysql://localhost/test?user=root&password=root");
            stmt = con.createStatement();
            rst = stmt.executeQuery("select * from Employee;");
            while(rst.next())
            {
        	    System.out.println();
        	    System.out.println(rst.getInt("EmployeeID"));
        	    System.out.println(rst.getString("EmployeeName"));
        	    System.out.println(rst.getString("EmployeePhone"));
        	    System.out.println(rst.getString("EmployeeAddress"));
        	    System.out.println(rst.getString("EmployeeCreateDate"));
        	    System.out.println();
            }
            
        } catch (SQLException ex) {
            ex.printStackTrace();
        } catch (InstantiationException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (IllegalAccessException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
        	try {
        		if(!con.isClosed())
        			con.close();
				//if(!rst.isClosed())
					//rst.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
        }
	}
}

输出：

话说mysql IDE很高大上的感觉！

总结:

1.自己写JDBC的底层很繁琐，于是有了Hibernate等ORM框架，下一节学习之。

2.MySql其实很强大，与sql server 语法差别并不大，值得学习。