var url = "jdbc:mysql://docker.for.mac.localhost:2881?useSSL=false";

var username = "root";

var password = "";

var conn =null;

var rs =null;

var st = null;

try{

conn = java.sql.DriverManager.getConnection(url, username, password)

st = conn.createStatement();

var sql = "select  * from test.appdemo";

rs = st.executeQuery(sql);

var metaData = rs.getMetaData();

var columnCount = metaData.getColumnCount();

for (let columnNumber = 1; columnNumber <= columnCount; columnNumber++) {

var catalogName = metaData.getCatalogName(columnNumber);

var className = metaData.getColumnClassName(columnNumber);

var label = metaData.getColumnLabel(columnNumber);

var name = metaData.getColumnName(columnNumber);

var typeName = metaData.getColumnTypeName(columnNumber);

var type = metaData.getColumnType(columnNumber);

var tableName = metaData.getTableName(columnNumber);

var schemaName = metaData.getSchemaName(columnNumber);

var isAutoIncrement = metaData.isAutoIncrement(columnNumber);

var isCaseSensitive = metaData.isCaseSensitive(columnNumber);

var isCurrency = metaData.isCurrency(columnNumber);

var isDefiniteWritable = metaData.isDefinitelyWritable(columnNumber);

var isReadOnly = metaData.isReadOnly(columnNumber);

var isSearchable = metaData.isSearchable(columnNumber);

var isReadable = metaData.isReadOnly(columnNumber);

var isSigned = metaData.isSigned(columnNumber);

var isWritable = metaData.isWritable(columnNumber);

var nullable = metaData.isNullable(columnNumber);

console.log(name,type,typeName)

}

while (rs.next()) {

var name = rs.getString(1);

console.log(name)

}

}

finally{

if(conn!=null){

conn.close();

}

if(rs!=null){

rs.close();

}

}

const Properties = java.util.Properties;

const properties = new Properties();

properties.setProperty("name","dlaong")

console.log(properties.getProperty("name"))

FROM ghcr.io/graalvm/graalvm-ce:21

RUN gu install nodejs

FROM dalongrong/graalvm-ce:21-node

WORKDIR /app

ENTRYPOINT [ "node","--jvm","--vm.classpath=/app/mysql-connector-java-5.1.47.jar","app.js" ]