用jsp分别连接oracle、mysql数据库

一、连接mysql

驱动要放到WEB-INF/lib目录下。驱动可以到官网下载。

测试代码：

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>

<html>
  <head>
    <title>连接MySql测试页面</title>
  </head>
  
  <body>
    <%
    try
    {
	    Class.forName("com.mysql.jdbc.Driver"); 
	    Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/suo","root","root"); 
	    Statement stat=con.createStatement();
	    ResultSet rs=stat.executeQuery("select * from user");
	    if(rs!=null)
	    {
	    	while(rs.next())
	    	{
	    		out.print(rs.getString("username")+"  ");
	    		out.print(rs.getString("password")+"<br/>");
	    	}
	    }
	    else{
	    	out.print("未查询到数据<br/>");
	    }
	    stat.close();
    }catch(SQLException sqle){
    	out.print(sqle.getMessage());
    }
    %>
  </body>
</html>

二、连接oracle

我的oracle是10.2.0.3版本的，驱动只需要ojdbc14dms.jar就可以了，看了官网上的说明：、

    -ojdbc14dms.jar

   Same as ojdbc14.jar, except that it contains additional code to support Oracle Dynamic Monitoring Service. Can only be used when dms.jar is in the classpath. dms.jar is provided as part of recent Oracle Application Server releases.

测试代码：

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>

<html> 
	<head> 
	<title>连接oracle10g的测试页面</title> 
	</head> 
  <body> 
	<%
		try{
			Class.forName("oracle.jdbc.driver.OracleDriver").newInstance(); 
			String url="jdbc:oracle:thin:@192.168.1.102:1521:orcl"; 
			String user="suo"; 
			String password="suo"; 
			Connection conn=DriverManager.getConnection(url,user,password); 
			Statement stmt=conn.createStatement();
			String sql="select * from teachers"; 
			ResultSet rs=stmt.executeQuery(sql); 
			while(rs.next()) 
			{
				out.print(rs.getString(1)+" ");
				out.print(rs.getString(2)+"<br/>"); 
			}

			rs.close(); 
			stmt.close(); 
			conn.close(); 

		}catch(SQLException e){
			out.print(e.getMessage());
		}
	%> 
    
  </body> 
</html> 

要注意写oracle的url时，ip要写本机的ip，即通过ipconfig查询出来的ip，不知道为什么，用localhost和127.0.0.1都会报找不到网络适配器的错误。

而且这两种方式都不用配置classpath。直接注册就可以了。