关于数据库的连接

try {
Class.forName("oracle.jdbc.driver.OracleDriver"); } catch(java.lang.ClassNotFoundException e) {
System.err.print("ClassNotFoundException: ");
System.err.println("Óë193ϵͳ½¨Á¢Á¬½Ó´íÎó!!");
                        e.printStackTrace();
                        System.exit(0);
        }
try{
ConnInput = DriverManager.getConnection("jdbc:oracle:thin:@10.108.3.17:1521:ctc","nc_bs","ptic185");
                 
                 System.out.println("Óëϵͳ½¨Á¢Á¬½Ó³É¹¦");
                 ConnInput.setAutoCommit(false);
                 }catch (SQLException ex){
                 ex.printStackTrace();
                 System.out.println("Óëϵͳ½¨Á¢Á¬½Ó´íÎó!");
                 System.exit(0);
                 }

解决方案 »

  1.   

    http://monolith.chem.soton.ac.uk/~hongchen/Computing/java/jdbc/Jsp-DB.htm
      

  2.   

    http://expert.csdn.net/Expert/topic/1514/1514415.xml?temp=.7136194
      

  3.   

    testoracle.jsp如下：  
        <%@ page contentType="text/html;charset=gb2312"%>  
        <%@ page import="java.sql.*"%>  
        <html>  
        <body>  
        <%Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();  
        String url="jdbc:oracle:thin:@localhost:1521:orcl";  
        //orcl为你的数据库的SID  
        String user="scott";  
        String password="tiger";  
        Connection conn= DriverManager.getConnection(url,user,password);  
        Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);  
        String sql="select * from test";  
        ResultSet rs=stmt.executeQuery(sql);  
        while(rs.next()) {%>  
        您的第一个字段内容为：<%=rs.getString(1)%>  
        您的第二个字段内容为：<%=rs.getString(2)%>  
        <%}%>  
        <%out.print("数据库操作成功，恭喜你");%>  
        <%rs.close();  
        stmt.close();  
        conn.close();  
        %>  
        </body>  
        </html>