win7系统下JDBC连接数据库.docVIP

win7系统下 JDBC连接数据库 一oracle10g数据库? 其使用的JAR包为?? 数据库下自带的classes12.jar package cn.oracleJDBC; import java.sql.*; public class DBConnection {?public static void main(String[] args) {??Connection conn = null;??try {???Class.forName(oracle.jdbc.driver.OracleDriver);???String url = jdbc:oracle:thin:@localhost:1521:orac;//orac为数据库的名???conn = DriverManager.getConnection(url, system, system);???if (conn != null) {????System.out.println(连接成功!);???}else{????System.out.println(连接不成功!+conn);???}???Statement stmt=conn.createStatement();???ResultSet rs=stmt.executeQuery(select * from scott.emp);???while(rs.next()){????System.out.print(rs.getString(1)+\t);???}??} catch (Exception e) {???e.getStackTrace();??}?}} 二SQLServer2008数据库? 其使用的JAR包为sqljdbc4.jar 连接代码如下： package com.sqlserver2008JDBC; import java.util.Properties;import java.sql.*; public class DBConnection {?public static Connection getConn() {??Connection conn = null;??try {???Class.forName(com.microsoft.sqlserver.jdbc.SQLServerDriver);???String url = jdbc:sqlserver://localhost:1433;databaseName=master;//master为数据库的名???Properties prop=new Properties();???prop.setProperty(user, sa);???prop.setProperty(password, sa);???conn=DriverManager.getConnection(url,sa,sa);??} catch (Exception e) {???e.printStackTrace();??}??return conn; ?} } 测试代码如下： package com.sqlserver2008JDBC; import java.sql.*;public class Program { ?public static void main(String[] args) {???? Connection conn=DBConnection.getConn();???? if(conn!=null){??? ? System.out.println(连接成功！);???? }??? ?}}