mysql与2008_MySQL与SQL2008远程数据库连接的浅谈区别

//SQl2008的数据库连接操作代码

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

public class SQL2008Connect {

private static String DRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";

private static String URL = "jdbc:sqlserver://192.168.1.108:1433;DatabaseName=studentdb";

private static String USER = "sa";

private static String PASS = "liuburu";

public static void main(String[] args) throws ClassNotFoundException, SQLException {

Class.forName(DRIVER);//加载数据库驱动程序

Connection con = DriverManager.getConnection(URL, USER, PASS);//获取连接对象

PreparedStatement statement = con.prepareStatement("select * from student");//处理语句

ResultSet result = statement.executeQuery();//获取结果集合

while(result.next()){

System.out.println(result.getString("id")+"  "+result.getString("name"));//输出表中的信息

}

con.close();//关闭数据库连接

}

}