myeclipse连接mysql问题。
已经建了context.xml文件
<?xml vertion="1.0" encoding="UTF-8"?>
<Context reloadable="true">
<resource name="jdbc/mydb" auth="Container"
type="javax.sql.DataSource" driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/mydb?autoReconnect=true"
username="root" password="capsa"
maxActive="100" maxIdle="30" maxWait="10000"/>
</Context>
连接mysql时还需要其他配置吗？我用的是myeclipse9.0
在调用时显示null.
public static void main(String[] args) {
// TODO Auto-generated method stub
  DBConnection dbConnection = new DBConnection();
  Connection connection = dbConnection.getConnection();
  System.out.print(connection);
}

  

public Connection getConnection()
{
Connection conn = null;
Context ctx;
  try 
  {
  ctx = new InitialContext();
  DataSource dataSource = (DataSource)ctx.lookup("java:comp/env/jdbc/mydb");
  conn = dataSource.getConnection();
  } catch (SQLException e)
{
e.printStackTrace();

} catch (NamingException e) {

} 

return conn;
   
}
在线等，希望高手帮忙看一下啊~~~~QQ：1658535306

------解决方案--------------------
首先我们在context.xml中配置
<?xml version="1.0" encoding="UTF-8"?>
<Context antiJARLocking="true" path="/MusicPro">
<Resource
name="jdbc/myDS"
type="javax.sql.DataSource"
driverClassName="com.mysql.jdbc.Driver"
maxIdle="2"
maxWait="5000"
username="root"
password="longke"
url="jdbc:mysql://127.0.0.1:3306/video"
maxActive="4"/>
</Context>

web.xml中
<resource-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/myDS</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>

最后别忘了把mysql驱动器拷贝到tomcat的lib目录下