CREATE TABLE Assets (
AssetID INT PRIMARY KEY,
AssetName VARCHAR(255) NOT NULL,
AssetType VARCHAR(255),
PurchaseDate DATE,
DepartmentID INT,
EmployeeID INT,
FOREIGN KEY (DepartmentID) REFERENCES Departments(DepartmentID),
FOREIGN KEY (EmployeeID) REFERENCES Employees(EmployeeID)
);
]]>
public Asset getAssetById(int assetId) {
String sql = "SELECT * FROM Assets WHERE AssetID = ?";
try (Connection conn = DriverManager.getConnection(DB_URL, USER, PASS);
PreparedStatement stmt = conn.prepareStatement(sql)) {
stmt.setInt(1, assetId);
ResultSet rs = stmt.executeQuery();
if (rs.next()) {
return new Asset(rs.getInt("AssetID"), rs.getString("AssetName"),
rs.getString("AssetType"), rs.getDate("PurchaseDate"));
}
} catch (SQLException ex) {
ex.printStackTrace();
}
return null;
}
]]>