Anderson

<?xml version="1.0" encoding="UTF-8"?>
<!--
   The JDBC module is used to configure the database access for MMBase. This module is essential. Do not remove it or make it inactive.
-->

  - When org.mmbase.module.database.JDBC is used, the MMBase Connection pooling is used.
    required properties for this class are:
    - url
    - user
    - password
    - supportclass
    - database
    - connections
    - probetime
    - host
    - driver
    - port
    - host
  -->
  <class>org.mmbase.module.database.JDBC</class>

    <property name="url">jdbc:mysql://$HOST:$PORT/$DBM</property>

    <!-- MySQL
    <property name="url">jdbc:mysql://$HOST:$PORT/$DBM</property>
    -->
    <!-- MySQL when it is configured to use utf-8. The data in the database will also be readable by other programs tested on mysql 4.1
    <property name="url">jdbc:mysql://$HOST:$PORT/$DBM?useUnicode=true&amp;characterEncoding=UTF-8</property>
    -->
    <!-- Oracle
         MM: I don' think this is regularly tested.
    <property name="url">jdbc:oracle:oci8:@$DBM</property>
    -->
    <!-- Informix
    <property name="url">jdbc:informix-sqli://$HOST:$PORT/$DBM:informixserver=[DBSERVERNAME]</property>
    -->
    <!-- Postgresql using the official postgresql driver
    <property name="url">jdbc:postgresql://$HOST:$PORT/$DBM</property>
    -->
    <!-- Postgresql using the http://jxdbcon.sourceforge.net/ dirver
         MM: I don' think this is regularly tested
    <property name="url">jdbc:pgsql:net//$HOST:$PORT/$DBM</property>
    -->
    <!-- MS Sql Server
         MM: I don' think this is regularly tested.
    <property name="url">jdbc:microsoft:sqlserver://$HOST:$PORT;DatabaseName=$DBM</property>
    --> 
       

    <!--
    name="user", what is the user we will use to login to the database
    -->
    <property name="user">root</property>

    <!--
    name="password", what is the password we will use to login to the database
    -->
    <property name="password">shieldprotect</property>

       <!--
    name="database",
    Most database engines allow you to store multiple databases in one engine.
    We need to select the database we want to use within this engine.
    Make sure you are using a 'empty' database when you start using mmbase to
    ensure you don't create problems for other users.
    -->
    <property name="database">mmbase</property>

    <!--
    name="connections"
    MMBase does its own database connection pooling  (keeping connections to the database open
    over several database queries, to speed up queries by not logging in and closing
    the connection on every query). 'connections' allows you to set
    the number of connections MMBase keeps open to the database.
    -->
    < property name="connections">20</property>

    <!--
    name="host", what host will we connect to (that is running the database)
    when you run mmbase on the same machine as this mmbase node it can
    be set to 'localhost'
    -->
    <property name="host">localhost</property>

    <!--
    name="driver", defines the classname for the used jdbc driver this can be
    obtained from the documentation from the jdbc driver you use.
    -->

    <!--
    MySQL:          com.mysql.jdbc.Driver                   ( http://www.mysql.com/downloads/api-jdbc.html )
    PostgreSQL:     org.postgresql.Driver                   ( http://jdbc.postgresql.org/download.html )
                    org.sourceforge.jxdbcon.JXDBConDriver   ( http://jxdbcon.sourceforge.net/ )
    Hypersonic:     org.hsql.jdbcDriver                     ( http://hsqldb.sourceforge.net/ )
    HsqlDB:         org.hsqldb.jdbcDriver                   ( http://hsqldb.sourceforge.net/ )
    Oracle:         oracle.jdbc.driver.OracleDriver
    Informix:       com.informix.jdbc.IfxDriver
    M$ SQL Server   com.microsoft.jdbc.sqlserver.SQLServerDriver    ( http://search.microsoft.com/search/results.aspx?st=b&na=88&View=en-us&qu=jdbc+sql+server+download )
    -->
  
 <property name="driver">com.mysql.jdbc.Driver </property>
    <!--
    name="port" what port is this database engine running on ? you can find the port in
    your database manual or ask the database admin. default ports for
    supported databases are :

    MySQL:          3306
    PostgreSQL      5432
    Informix        1527
    M$ SQL Server   1433
    Oracle          1521
    HSQL            0
    -->
    <property name="port">13306</property>
</module>

Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:13306/db","root","password");
Statement stat = conn.createStatement();
ResultSet rs = stat.executeQuery("select * from tb_article where category='"+category+"' ");
<ul>
<%while(rs.next()){%>
<li>
<a href="showArticle.jsp?id=<%=rs.getString("id")%>"> <%=rs.getString("title")%> </a> <%=rs.getString("createdDate")%>
</li>