jsp连接数据库没成功，这是为什么

Question

我的连接池在后台也就是MyEclipse上运行成功，但是拿到tomcat中的项目里，为什么就不行了呢？

Answer 1

<%@ page language="java" pageEncoding="gbk"%>
<%@page import="java.sql.Connection"%>
<%@page import="javax.naming.Context"%>
<%@page import="javax.naming.InitialContext"%>
<%@page import="javax.sql.DataSource"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.ResultSet"%>

<%
//连接池的获取

try {
        Class.forName("com.mysql.jdbc.Driver");
    } catch (ClassNotFoundException e1) {
        // TODO Auto-generated catch block
        e1.printStackTrace();
    }//加载数据库驱动Class.forName();
    Connection  conn = DriverManager.getConnection

("jdbc:mysql://192.168.1.115:3306/synuky", "root", "hopeshine");

ResultSet rs = null;   

String sql = "select * from sys_login";

java.sql.PreparedStatement preparedStatement;



try{   

    preparedStatement =conn.prepareStatement(sql); 
    rs = preparedStatement.executeQuery();
    while(rs.next()) {

%>

out.println("执行结果：＝＝
<%=rs.getString(2)%>
<% }

    }catch(Exception e){   
       System.out.println("e:"+e);   
    }

%>