谁有JSP连接ORACLE数据库的JAVABEAN?

Question

public static Connection getConnection() throws Exception{
        Connection conn = null;
        try{
            Class.forName("oracle.jdbc.driver.OracleDriver");
            String url="jdbc:oracle:thin:@192.168.0.50:1521:oradb";
            String userName="usern";
            String userPass="pass";
            conn = DriverManager.getConnection(url, userName, userPass);
        }catch(Exception ex){
           throw ex;
        }
        return conn;
    }

Answer 1

借问一下：jdbc:oracle:thin:@192.168.0.50:1521:oradb
这里面的thin是什么意思？

Answer 2

import java.sql.*;public class Dbconnect
{    public Dbconnect()
    {
        sDBDriver = "org.gjt.mm.mysql.Driver";
        conn = null;
        rs = null;
        stmt = null;
        try
        {
            Class.forName(sDBDriver);
        }
        catch(ClassNotFoundException classnotfoundexception)
        {
            System.err.println("Class not found!" + classnotfoundexception.getMessage());
        }
    }    public ResultSet executeQuery(String s)
    {
        rs = null;
        try
        {
            conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/db", "user", "password");
            stmt = conn.createStatement();
            rs = stmt.executeQuery(s);
        }
        catch(SQLException sqlexception)
        {
            System.err.println("aq.executeQuery:" + sqlexception.getMessage());
        }
        return rs;
    }    public int executeUpdate(String s)
    {
        int i = 0;
        try
        {
            conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/db", "user", "password");
            Statement statement = conn.createStatement();
            i = statement.executeUpdate(s);
        }
        catch(SQLException sqlexception)
        {
            System.err.println("aq.executeQuery:" + sqlexception.getMessage());
        }
        return i;
    }    public static void main(String args[])
    {
        String s = "select * from user_table";
        Gslt_dbconnect gslt_dbconnect = new Gslt_dbconnect();
        ResultSet resultset = null;
        resultset = gslt_dbconnect.executeQuery(s);
        System.out.println("begin:");
        try
        {
            String s3;
            for(; resultset.next(); System.out.println(s3))
            {
                String s1 = resultset.getString("name");
                System.out.println(s1);
                String s2 = resultset.getString("address");
                System.out.println(s2);
                s3 = resultset.getString("email");
            }        }
        catch(SQLException _ex) { }
        System.out.println("end.");
    }    String sDBDriver;
    Connection conn;
    ResultSet rs;
    Statement stmt;
}