java连接MySQL数据库的方式

  String url="jdbc:mysql://localhost:3306/test";

                   String Driver="com.mysql.jdbc.Driver";

                   String username="root";

                   String password="123456";

 

                   Class.forName(Driver);

                   Connection conn=DriverManager.getConnection(url,username,password);

 String url="jdbc:mysql://localhost:3306/test";

                   String username="root";

                   String password="123456";

 

                   new com.mysql.jdbc.Driver();

                   Connection conn=DriverManager.getConnection(url,username,password);

 <Context reloadable="true">

 

    <!-- Default set of monitored resources -->

    <WatchedResource>WEB-INF/web.xml</WatchedResource>

 

    <Resource name="jdbc/mysql" auto="Container" type="javax.sql.DataSource" maxActive="100" maxIdle="30" maxWait="10000" username="root" password="123456" driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/test"/>

 

    <!-- Uncomment this to disable session persistence across Tomcat restarts -->

    <!--

    <Manager pathname="" />

    -->

 

    <!-- Uncomment this to enable Comet connection tacking (provides events

         on session expiration as well as webapp lifecycle) -->

    <!--

    <Valve className="org.apache.catalina.valves.CometConnectionManagerValve" />

    -->

 

</Context>

Context context=new InitialContext();

DataSource ds=(DataSource) context.lookup("java:/comp/env/jdbc/mysql");

Connection conn=ds.getConnection();