jdbc

Class.forName("驱动");

Connection con = DriverManager.getConnection(URL,NAME,PASSWORD);
String sql = "...";
PreparedStatement ps = con.prepareStatement(sql);
ResultSet rs = ps.executeQuery();||int a = ps.executeUpdate()

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection con = DriverManager.getConnection("jdbc:microsoft::sqlserver://localhost:1433;Databasename=news","sa","sa");
PreparedStatement ps = con.prepareStatement(sql);
ResultSet rs = ps.executeQuery();
    
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1527:MyOral","name","password");
PreparedStatement ps = con.prepareStatement(pl/sql)
ResultSet rs = ps.executeQuery();

jdbc对oracle存储过程的引用:
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@192.168.10.18:1521:ORCL", "scott", "scott");
CallableStatement cs = con.prepareCall("{call pro_separatedPage(?,?,?,?,?,?)}");
cs.setString(1, "myTable");
cs.setInt(2, 5);
cs.setInt(3, 1);
cs.registerOutParameter(4, oracle.jdbc.OracleTypes.INTEGER);
cs.registerOutParameter(5, oracle.jdbc.OracleTypes.INTEGER);
cs.registerOutParameter(6, oracle.jdbc.OracleTypes.CURSOR);
//执行CallableStatement对象
cs.execute();
int totalRows = cs.getInt(4);//此处4这个数是由上面问号的位置决定的
int totalPages = cs.getInt(5);
ResultSet rs = (ResultSet)cs.getObject(6);
System.out.println("总行数 = "+totalRows);
System.out.println("总页数 = "+totalPages);

jdbc对sqlserver存储过程的引用:
Class.forName("...");
Connection con = DriverManager.getConnection("...");
CallableStatement cs = con.prepareCall("{call sp_proc(?,?,?)}");
cs.setInt(1,7788);
cs.setString(2,"aaa");
cs.registerOutPut(3,java.sql.types.Integer);
cs.execute();
int a = cs.getInt(3);