使用 jsp 连接oracle数据库?帮忙.写一个简单例子

<%
String url= "jdbc:oracle:thin:@数据库机器名或IP:1521:数据库实例名";
Connection con=null;
String user=request.getParameter("userName");
String password=request.getParameter("password");
try
{
Class.forName(forname);
con =DriverManager.getConnection(url,user,password);
out.write("连接成功！");
}
catch(Exception e)
{
e.printStackTrace();
out.write("连接失败！");
}
%>

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class TestOracleConn {
public static void main(String[] args) {
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
//1521为端口名，orcl为oracle提供的服务名
Connection c= DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:orcl","system","sa");
System.out.println("success!");