TestParameterisasi.ts

app.get('/users', (req, res) => {
  const username = req.query.username;
  const sql = 'SELECT * FROM users WHERE username = ?';

  db.query(sql, username, (err, results) => {
    if (err) {
      console.error('Error executing query:', err);
      return res.status(500).send('Error executing query');
    }

    res.json(results);
  });
});