第一种方式:通过数据库本身的jdbc driver连接到数据库
classs.forname("oracle.jdbc.driver.oracledriver");
connection conn = drivermanager.getconnection("jdbc:oracle:thin:@192.168.1.33:1521:huihoo","scott","tiger");
第二种方式:通过jdbc-odbc桥连接到数据库
class.forname("sun.jdbc.odbc.jdbcodbcdriver");
connection conn = drivermanager.getconnection("jdbc:odbc:192.168.1.33","scott","tiger");
192.168.1.33为数据源
完整的用户登录
properties props = new properties();
props.put("user", "scott");
props.put("password", "tiger");
driver mydriver = (driver) class.forname("oracle.jdbc.driver.oracledriver").newinstance();
conn = mydriver.connect("jdbc:oracle:thin:@192.168.1.33:1521:huihoo", props);
conn.close();
system.out.println("成功登录.");
system.out.println("欢迎您 "+props.getproperty("user")+"!");
闽公网安备 35060202000074号