Liferay Database Groovy - nishant24tankariya/Liferay GitHub Wiki

Show specific table data

import com.liferay.portal.kernel.dao.jdbc.DataAccess

def connection = DataAccess.getConnection()

def sql = "SELECT * FROM user_"

def stmt = connection.createStatement()

def resultSet = stmt.executeQuery(sql)

def rsMetaData = resultSet.getMetaData()

out.print("<table border='1'><thead>")

for(int i = 1; i<=rsMetaData.getColumnCount(); i++) {
    out.println("<th>" + rsMetaData.getColumnName(i) + "</th>");
}

out.println("</thead><tbody>")

while (resultSet.next()) { 
    out.print("<tr>")
    for(int i = 1; i<=rsMetaData.getColumnCount(); i++) {
        out.print("<td>" + resultSet.getObject(i) + "</td>")
    }
    out.print("</tr>")
}

out.print("</tbody></table>")

connection.close()
⚠️ **GitHub.com Fallback** ⚠️