String drivername="oracle.driver.JDBCDriver"//这是你的数据库的jdbc驱动类名
String url = "oracle:jdbc:thin:@localhost:1521:testdb"
String username = "yourname"
String password = "password"
Class.forName(drivername)
Connection conn = DriverManager.getConnection(url, username, password)
...
...
创建视图 CREATE VIEW VIEW_name AS SELECT empno, ename, sal, deptno FROM emp WHERE deptno = 10
删除视图 drop VIEW VIEW_name
查询视图 SELECT id, name, salary FROM VIEW_name
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)