harbernate怎么连接oracle

harbernate怎么连接oracle

1)首先你要有java连接oracle数据库的驱动类,下载好后导入到工程里2)代码:import java.sql.*;public class JDBCTest { public static void main(String[] args) throws ClassNotFoundException, SQLException{ //1.准备参数 String ip = "192.168.0.26"; String sid = "tarena"; String port = "1521"; String dbUser = "openlab"; String dbPassword = "open123"; String driver = "oracle.jdbc.driver.OracleDriver"; //2.构造驱动实例 Class.forName(driver); //3.创建连接 //连接字符串是固定的形式,oracle的形式: String url = "jdbc:oracle:thin:@" + ip + ":" + port + ":" + sid; Connection conn = DriverManager.getConnection (url, dbUser, dbPassword); //4.执行SQL语句 String sql = "select id, password, name from user_sd1104 " + "where id = 1001 and password = '1234'"; Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery(sql);//执行sql语句 while(rs.next()){ int id = rs.getInt(1); String pwd = rs.getString(2); String name = rs.getString(3); System.out.println("welcome," + name); } rs.close(); stmt.close(); conn.close(); }}

如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！

点此我要举报以上问答信息