Java 数据库连接（数据库为bbs，数据源名为test）1、直接连接mysql数据库（先把mysql的驱动加载到工程中：选中工程：右键property---javabuildpath---libraries：再选择AddExternalJARS找到驱动存放位置把它加载进来）package dbLink;package dbLink;import java.sql.*;public class DataBaseConnection {public static Connection getConnection(){Connection conn = null;try {Class.forName("com.mysql.jdbc.Driver");conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/bbs","root","123");} catch (ClassNotFoundException e) {// TODO Auto-generated catch blocke.printStackTrace();} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();}return conn;}public static void closeConnection(Connection conn){if(conn!=null)try {conn.close();} catch (SQLException e) {e.printStackTrace();}}public static void closeResultSet(ResultSet rs){if(rs!=null)try{rs.close();}catch(SQLException e){e.printStackTrace();}}public static void closePreparedStatment(PreparedStatement ps){if(ps!=null)try{ps.close();}catch(SQLException e){e.printStackTrace(); } }}2、通过数据源于mysql连接package dbLink;import java.sql.*;public static Connection getConnection(){Connection conn = null;try {Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");conn=DriverManager.getConnection("jdbc:odbc:test","root","123");} catch (ClassNotFoundException e) {// TODO Auto-generated catch blocke.printStackTrace();} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();}return conn;}public static void closeConnection(Connection conn){if(conn!=null)try {conn.close();} catch (SQLException e) {e.printStackTrace();}}public static void closeResultSet(ResultSet rs){if(rs!=null)try{rs.close();}catch(SQLException e){e.printStackTrace();}}public static void closePreparedStatment(PreparedStatement ps){ if(ps!=null)try{ps.close();}catch(SQLException e){e.printStackTrace();}}}3、sqlserver直接连接数据库（先把sqlserver的驱动加载到工程中：选中工程：右键property---javabuildpath---libraries：再选择AddExternalJARS找到驱动存放位置把它加载进来）package dbLink;import java.sql.*;public class DataBaseConnection {public static Connection getConnection(){Connection conn = null;try {Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");conn=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=bbs","sqls erver用户名","sqlserver用户密码");} catch (ClassNotFoundException e) {// TODO Auto-generated catch blocke.printStackTrace();} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();} return conn;}public static void closeConnection(Connection conn){if(conn!=null)try {conn.close();} catch (SQLException e) {e.printStackTrace();}}public static void closeResultSet(ResultSet rs){if(rs!=null)try{rs.close();}catch(SQLException e){e.printStackTrace();}}public static void closePreparedStatment(PreparedStatement ps){if(ps!=null)try{ps.close();}catch(SQLException e){e.printStackTrace(); } }}4、sqlserver通过数据源连接数据库package dbLink;import java.sql.*;public class DataBaseConnection {public static Connection getConnection(){Connection conn = null;try {Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");conn=DriverManager.getConnection("jdbc.odbc.test","sqlserver用户名","sqlserver用户密码");} catch (ClassNotFoundException e) {// TODO Auto-generated catch blocke.printStackTrace();} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();}return conn;}public static void closeConnection(Connection conn){if(conn!=null)try {conn.close();} catch (SQLException e) {e.printStackTrace();}}public static void closeResultSet(ResultSet rs){if(rs!=null)try{rs.close();}catch(SQLException e){e.printStackTrace();}}public static void closePreparedStatment(PreparedStatement ps){if(ps!=null)try{ps.close();}catch(SQLException e){e.printStackTrace(); } }}。