<html>
<body>
<%@ page import="java.sql.*"%> <%
String url= "jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.67)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=hydb)))";
String user = "scott";
String password = "tiger"; Statement stmt=null;
Connection conn=null;
ResultSet rs=null;
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection(url,user,password);
stmt = conn.createStatement();
rs=stmt.executeQuery("select * from dept"); while(rs.next()){
out.print(rs.getString(1)+"<br>");
}
}catch(Exception e){
out.print("Exception:"+e.getMessage());
}
rs.close();
out.print("OK");
%>
</body>
</html>
<body>
<%@ page import="java.sql.*"%> <%
String url= "jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.67)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=hydb)))";
String user = "scott";
String password = "tiger"; Statement stmt=null;
Connection conn=null;
ResultSet rs=null;
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection(url,user,password);
stmt = conn.createStatement();
rs=stmt.executeQuery("select * from dept"); while(rs.next()){
out.print(rs.getString(1)+"<br>");
}
}catch(Exception e){
out.print("Exception:"+e.getMessage());
}
rs.close();
out.print("OK");
%>
</body>
</html>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货