Java数据库连接

1、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.forNam

2、e(com.mysql.jdbc.Driver); conn=DriverManager.getConnection(jdbc:mysql:/localhost:3306/bbs,root,123); catch (ClassNotFoundException e) / TODO Auto-generated catch block e.printStackTrace(); catch (Exception e) / TODO Auto-generated catch block e.printStackTrace();return conn;public static void closeC

3、onnection(Connection conn) if(conn!=null)try conn.close(); catch (SQLException e) e.printStackTrace();public static void closeResultSet(ResultSet rs) if(rs!=null)tryrs.close();catch(SQLException e) e.printStackTrace();public static void closePreparedStatment(PreparedStatement ps) if(ps!=null)tryps.c

4、lose();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

5、) / 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

6、(ResultSet rs)if(rs!=null)tryrs.close();catch(SQLException e)e.printStackTrace();public static void closePreparedStatment(PreparedStatement ps) if(ps!=null)trye.printStackTrace();3、sqlserver 直接连接数据库 (先把 sqlserver 的驱动加载到工程中：选中工程：右键 property-javabuildpath-libraries :再选择 AddExternalJARS找到驱动存放位置把它加载进来)

7、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 用

8、户密码 ); catch (ClassNotFoundException e) / TODO Auto-generated catch block e.printStackTrace(); catch (Exception e) / TODO Auto-generated catch block e.printStackTrace(); return conn;public static void closeConnection(Connection conn) if(conn!=null)try conn.close(); catch (SQLException e) e.printStac

9、kTrace();public static void closeResultSet(ResultSet rs)if(rs!=null) tryrs.close();catch(SQLException e) e.printStackTrace();public static void closePreparedStatment(PreparedStatement ps) if(ps!=null)trye.printStackTrace(); 4、sqlserver 通过数据源连接数据库 package dbLink;import java.sql.*;public class DataBas

10、eConnection 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)tryrs.close();c