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

win7系统下 JDBC连接数据库 一oracle10g数据库 其使用的JAR包为 数据库下自带的classes12.jarpackage 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(连接成功!);elseSystem.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